V3.5 14/08/19
UD0089
Page 260
This Document is uncontrolled unless over stamped "CONTROLLED DOCUMENT"
Server Name
Enter the name of the SQL Server that will host the database.
Database Name
Select the name of the SQL Database.
Connection String
Set to 'Default Connection String' unless you are connecting to a server that has TLS 1.0 disabled, in
which case select 'Support for non TLS 1.0 enabled servers'.
NOTE:
The client machine must have Windows 7 or higher in order for the 'Support for non
TLS 1.0 enabled servers' option to work.
Command Time-out
Adjust the command time-out value in seconds accordingly. The default command time-out value is
60 seconds. If you experience Command Time-out Error messages then increase the command
time-out values in increments of 10 until the errors no longer appear.
NOTE:
It is not recommended that you enter a command time-out value below 30 seconds.
Use Integrated Security
Select this option to allow
Match user via database
When using integrated security, select this option so that Traka32 matches the SQL Server Login
entered into the
window to the user name returned by the SQL Server. If the user
logging is has administrative rights to the SQL Server (direct or inherited) then they will be given full
unrestricted access to the Traka32 software.
Match user via environment
When using integrated security, select this option so that Traka32 matches the SQL Server Login
entered into the
window to the user name returned by the Windows. This is useful if the
user logging is has administrative rights to the SQL Server but you want to identify them as a
standard user within Traka32.
Prefix with domain name
When using the match user via environment option, set this option if it’s a requirement to prefix the
SQL Server Login name with the Domain name. For example <DOMAIN NAME\USER NAME>. If this
option is not set only the user name will be matched upon.
