V3.5 14/08/19
UD0089
Page 392
This Document is uncontrolled unless over stamped "CONTROLLED DOCUMENT"
3.17.3
SOFTWARE ACCESS USING A MICROSOFT SQL SERVER DATABASE
This section assumes that the database has been successfully installed and initialised.
When using a Microsoft SQL Server Database, some form of login will always be required.
Although Traka32 only requires one login, there are two levels of authentication that occurs before allowing access to
Traka32. The first level is the SQL Server Authentication. This is where the SQL Server must authenticate the user
connecting to the database. This can either be done with Integrated Security or SQL Server Authentication. The
second level is matching up the Login Name to that of a user record in the Traka32 Database itself.
When logging into Traka32 for the first time with a new database you will need to use the SQL Server's own SA
account Login Name and Password. This will be available from the SQL Server administrator. The SA login will allow
access to all areas of the Traka32 software including the
For more details on Integrated Security and SQL Server Authentication please refer to the
Setting up SQL Server User Accounts (SQL Server Authentication Only)
This does not apply if you are using Integrated Security.
The first step is to create SQL Server User Accounts using the Traka SQL Server Manager.
1.
Load the Traka SQL Server Manager software by clicking on the
icon from the Traka program group in
the Start menu.