7.1 Setting up Additional Users on the Network
Setting up Additional Users on the Network
In order for multiple users to connect to the database via the network, the following changes need to
be made to the server (PC) where the JT databases reside, to make communication possible. It is
recommended to temporarily disable the firewall and antivirus, and then follow the steps below. Only
when all communications are successful should you re-enable the firewall. If communication is still
possible through the firewall, re-enable the antivirus software. This procedure will help eliminate any
possible causes of connection failure to the database.
It is also possible to use JT Manager to configure SQL settings, from the Multiple Users tab.
1. Including SQL Security
Open ‘Microsoft SQL Server Management Studio Express’ by going to ‘Start’ and then the
appropriate entry ‘Microsoft SQL Server’. Note that the menu entry name and some of the below
steps may differ slightly between Windows and SQL versions.
Mixed mode:
Right click on the server (right at the top left of the object explorer) and select ‘Properties’.
Select ‘Security’ from the top left of this new window.
Ensure ‘Server Authentication’ is set to ‘SQL Server and Windows Authentication’ and click ’OK’.
2. Update security in JT
Check the ‘C:\JT-Data\Config\Jarrison.ini’ file, ensure that ‘Security= SQL’ is set.
3. Create the JT User
In the object explorer of Management Studio, click the ‘+’ next to ‘Security’.
Right click on ‘Logins’ and select ‘New login’.
In the new window enter ‘jt’ (lower case) as the ‘Login name’
Now click on the ‘SQL Server Authentication’ radio button.
The password is ‘jtime’ (lowercase).
Confirm the password ‘jtime’.
Deselect 'Enforce Password policy'.
NB: Leave default database as ‘master’.
Click on ‘Server Roles’ from the list on the left and select ‘sysadmin’ only.
Click ‘OK’.
NB: If the ‘jt’ user on the server cannot have the default password ‘jtime’, you can change the
password to whatever you need it to be and then modify the entry in the ‘C:\JT
Data\Config\Jarrison.ini’ file to ‘Security= SQLA’. Then when you start JT again you will be
prompted to enter your new SQL password for the server. If the password is incorrect it will warn you
and you will have to retry. If the password is correct JT will encrypt this password into the .ini file and
each time you log in JT will decrypt this password for the server and use it to gain access.
4. Enable TCP/IP
In ‘SQL Server Configuration Manager’ (‘Start’, ‘Microsoft SQL Server’, ‘Configuration Tools’)
Click the ‘+’ next to ‘SQL Server Network Configuration’.
Now click on ‘Protocols for’ the correct SQL instance, this will list the protocols on the right of the
window.
Double-click on the TCP/IP protocol and this will open the Properties window. Set Enabled to ‘Yes’.
Now click on ‘OK’. (A connection to the database should now be possible.)
If the firewall was temporarily disabled and needs to be re-enabled, enable it and attempt to logon to
JT.
If the connection cannot now be made to the database, the ports on the firewall need to be opened by
following these steps below.
You will need to restart the SQL Server Services for the changes to take effect.
5. Configure JT to access SQL Server through the Firewall
Open ‘SQL Server Configuration Manager’. Note the below steps may vary slightly according to the
version of SQL installed.
Click the ‘+’ next to ‘SQL Server Network Configuration’.
Now click on ‘Protocols for’ the correct SQL instance, this will list the protocols on the right of the
window.
Named Pipes and TCP/IP must both be enabled.
Double click on the TCP/IP protocol and this will open the properties window, and then click onto the
‘IP Addresses’ tab.
In the ‘IP All’ section, next to the ‘TCP Port’ box, type 1550 and click ‘OK’. (leave ‘Dynamic’ as is).
SQL Server now needs to restart which can be done from this SQL Server Configuration Manager
window. Click on ‘SQL Server Services’ near the top left of the window, then right click on ‘SQL
Server’ in the right pane of the window and select ‘Restart’.
6. Add a port for SQL Express to the Firewall
From Control Panel, click on Windows Firewall (the firewall should now be ‘On’) now click on
‘Advanced Settings’ then ‘Inbound Rules’, New Rule, Port. Do the same for ‘Outbound Rules’.
Type in a description (SQL Express) and enter the default SQL port number 1550 (as configured for
SQL above).
Select ‘TCP’ and click ‘OK’.
Note that on large or corporate sites, specific ports may be set for SQL. Check with the IT
administrator before changing defaults.
7. Add a port for SQL Browser to the Firewall
Click ‘Add a port’ and type in a description (SQL Browser). Enter the port number 1434 (default for
SQL Browser). Select ‘UDP’ and click ‘OK’. Do this for Inbound and Outbound rules.
Related Articles
5.1 Setting Licence Information
Setting Licence Information Click on ‘Setup’ then ‘Registration’ from the menu bar.Then click the ‘Edit’ button at the bottom to make changes. Modification of below details can take place at any time, per needs of the client, however most options ...24.2 Extra
Extra Hikvision devices need to have their password entered from this tab. Dahua devices need to have their username and password entered from this tab. Used by JT Trace - if the JT Trace feature is enabled, this option will be selectable. It will ...19.1 User Profiles/Details
User Profiles A user login account is necessary for each operator who needs to sign in to JT. Every user has a name, description and password. The user will login using their User Name and Password. Usernames are not case sensitive, but passwords ...23.1 Send Email to Users
Send Email to Users This option allows emails to be sent to any users who have a valid email address filled in User Profiles. SMTP must be set up in order for the feature to work.21.1 User Filters
User Filters These filters are created and function similarly to standard employee list filters but only can be applied to user accounts. To manage these filters click on ’User Filters’ under ‘Users’ on the menu bar. When a user is assigned to a view ...