Please use to following instructions if moving to a new server.

Install SQL on new server

A.    Ensure that the new location has met the installation requirements for the server and client workstation:

ð        SQL Server® installed (2008 R2 or higher)

ð        SQL Management Studio® installed

ð        SQL Server®  Administrator account login name and password provided

ð        All TRAIN TRACK users added to a user group under Active Directory

ð        Appropriate SQL Native Client driver installed on client workstation

ð        Microsoft® Access® 2010/2013/2016 installed on client workstation (2010 SP1 or higher) *only necessary if you do not use the default install settings

B.    Back up your current database on previous server:

1.     Open SQL Management Studio and find your database in the navigation panel on the left

2.     Right click on the name of your database, chose Tasks and then Backup

3.     In the pop up window

a.     Backup Type: Full

b.     Backup Component: Database

c.     use the default destination folder and name (usually something like, C: Program Files\ Microsoft SQL Server \ MSQL12.MSSLSERVER\MSSQL\Backup\filename.bak)

4.     Click OK

5.     Move the filename.bak backup file to a location accessible from the new server

C.    Restore database to new location:

1.     Open SQL Management Studio on the new server, right click on Databases and click New

2.     Name your new database, TRAINTRACK and click ok

3.     Right click on the new database (TRAINTRACK) and click on Tasks > Restore > Database

4.     In the pop up window change the Source to Device, click the “…” button, click Add and navigate to your previously saved backup, click OK

5.     Change the Destination – select the TRAINTRACK database you just created from the pulldown menu

6.     Choose Options on the left and make sure ‘Overwrite the Existing Database’ is selected

7.     Uncheck “Tail Log backup”

8.     Click OK

D.    Set Permissions:

1.     In SQL Management Studio on the new server, find the Security folder in the navigation pane on left. Right click and select New Login

2.     In the popup widow under General, confirm Windows Authentication is checked and click on the Search button

3.     Leave defaults as is and click on the Advanced tab and then Find Now

4.     Select your TRIAN TRACK user group or individual user names and click OK and OK again

5.     From general, click on User Mapping and assign your users read / write permission (check db_datareader and db_datawriter)

6.     Click OK

E.    Setup the ODBC connection between the client and server

1.     From client computer, navigate to Control Panel > Administrative Tools > Data Sources (ODBC)

2.     In the pop-up window select the ‘User DSN’ tab and choose Add

3.     Select SQL Native Client as your driver (from the very bottom of the list). Click Finish.

4.     In the “Create New Data Source to SQL Server ’ window type the name TTSERV

a.     Leave the description field blank

b.     Select the SQL server with your TRAINTRACK database from the drop down menu.

c.     Click Next.

5.     Select ‘With Integrated Windows Authentication,”  click next

6.     Check “Change the default database to” and select your TRAINTRACK database from the pulldown menu. Click next

7.     On the following screen, leave all options blank and click Finish.

8.     In the ODBC Microsoft SQL Server Setup window, click ‘Test Data Source…”

9.     You should see a TESTS COMPLETED SUCCESSFULLY! Message. Click OK to close window and then OK again.

10.   Click OK.

F.    Install the TRAIN TRACK client

1.     From the client computer, browse to the location where you unzipped the TRAIN TRACK® installation files.

2.     If you do not have Microsoft® Access® installed and wish to install the free runtime version, locate the installation file TTCS_10_RTSetup.exe and double-click to open. Follow the instructions on your screen to install the client

3.     If you already have the full version of Microsoft® Access® 2010 installed, locate the installation file TTCS_10_Setup.exe and double-click to open.

4.     Once installed, open the application. You should see the initial screen. You may select to import data from a previous version, enter a registration code, or start the 30-day trial.