Task 1.6(c): Complete Database Setup, SQL Server Alternative

Purpose: Connects the TraCS master computer to the TraCS SQL Server databases.

Requirements: Master computer.

1. Open TraCS Configuration Manager.

2. Sign in with account 00001, password tracs.

3. Click Setup tab.

4. Click the Database Connections button.

5. Select Database Connection Strings.

   Open

   

6. Click Import DB Connections.

   Open

   

   1. Expand the database connection string item.

   2. Select the Support_FieldUnit, Data_FieldUnit, Users_FieldUnit, and Log_FieldUnit entries. (Use the <Ctrl> key to select multiple entries at the same time.)

   3. Click OK.

7. Edit the database connection for the field unit’s version of the data database.

   Open

   

8. Select Data_FieldUnit under the Database Connection Strings item.

   Open

   

9. Change the Database to SQL Server.

10. Choose Application User ID and Password.

11. In the Server Name field, enter the name of the server hosting the SQL server databases. This is the same as the Data Source in the connection string.

12. In the Database Name field, enter tracs_data. This will populate the Catalog portion of the connection string.

13. Enter the user ID and password needed to access the database.

14. Click Test to verify the connection string.

15. Click OK to close the database connections editor.

16. Start SQL Server Management Studio (SSMS).

17. Create the tables to store the form data in the tracs_data database by running the “Delta” SQL script. The script will be located in the TraCS network folder (from task 1.2, step 6b) under the DBData\SQLScripts folder. The name of the script takes the form of <Timestamp>Delta.sql. If there is more than one “Delta” script present, run the one with the most current timestamp.