Q: How do I add a new client workstation for my database?

A: You will need to add the user to the SQL database, add the user in TRAIN TRACK®, and install the interface on the workstation.

Set permissions for the new user's Windows® login in SQL Server® Management Studio (SSMS)

The easiest way to grant permission for a new user is to add the user to your Windows® user group that already has permission for the database. If you did not use a Windows® user group, you may add the user individually by following these steps:

1. Open SQL Server® Management Studio (SSMS) and connect to the server.
2. In the navigation tree on the left, locate the "Security" folder. Right-click and select "New Login".
3. In the pop-up widow under "General", confirm that "Windows® Authentication" is checked, and click on the "Search" button.
4. Click on the "Advanced" tab.
5. Click "Find Now".
6. Select your TRAIN TRACK® user group (or individual user names) and click "OK" and "OK" again.
7. Back in the first pop-up window, select "User Mapping".
8. Highlight the "TRAINTRACK" database in the upper window and check "db_datareader" and "db_datawriter" in the lower window.
9. Click "OK".

Install the Client interface

1. Run the TRAIN TRACK® installer (or unzip the files to a folder on your workstation).
2. Launch TRAIN TRACK®.
3. Click "Refresh Tables".
4. Type in the name of your SQL Server® and your database name (usually TRAINTRACK).
5. Select "Windows® Authentication" and click "Link Tables". Once the tables are linked, you should see either the dashboard (if your user is already listed within TRAIN TRACK®) or a login screen. If you see the login screen, click "Edit Users" and add your Windows® login name as a user (OR have a current administrator add the new user).