Set permissions for the new user's Windows login in SQL Management Studio
If you are adding a new, Licensed TRAIN TRACK user, you will need to add permission for the back-end database. 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 Management Studio 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 window under "General", confirm that "Windows Authentication" is checked and click on the "Search" button.
4. Click on the "Advanced" tab and click "Find Now".
5. Select your TRAIN TRACK user group or individual user names and click "OK" and "OK" again.
6. Back in the first pop-up window, select "User Mapping".
7. Highlight the "TRAINTRACK" database in the upper window and check "db_datareader" and "db_datawriter" in the lower window. Click "OK".

Add the ODBC on the new workstation:

1. Open the Windows "Control Panel" and select "Administrative Tools > ODBC Data Sources (32-bit)".
2. Select the "USER DSN" tab and click "Add".
3. In the "Create New Data Source" window, select the SQL Native Client (it is usually the one at the bottom). If you don't have the Native Client, select the SQL driver.
4. The Create a New Data Source to SQL Server window will open. Enter the following and click "Next".
   1. Name: TTSERV
   2. Description: (optional) Type in a description
   3. Server: select (or type in) your SQL server
5. Select "with integrated windows authentication"or "with windows NT authentication" and click "Next".
6. Check the box that says "Change the default database to:" and select "TRAINTRACK". Click "Next".
7. Click "Finish".
8. Click "Test Data Source". You should see a message that the test was successful. Click "OK".

Install the Interface from the .zip folder (non-installer version)

1. Create a new folder C:\Program Files (x86) called "TRAINTRACK".
2. Download the TRAIN TRACK installation folder to a known location. Right-Click in the file and select "Extract All" and select to extract into the folder you created in the previous step.
3. Within in this folder, locate the program file, TRAINTRACK12.accde (or TRAINTRACK10.mde if using version 10), and create a shortcut to the desktop.
4. Launch TRAIN TRACK by clicking the shortcut. It should automatically connect to your server database.
5. From the Ribbon, Database Administration tab, Click "Edit Users" and enter your registration code.
6. Click "Edit Users" and add your Windows login name as a user.