Installing TAD on SQL Server

!Prerequisites:
1. Refer to the Requirements Before Installing section before continuing.

TAD works with two specific databases.

• Viewpoint
• KDS-HRIM
  

Complete the following steps for both databases.

1. Execute the SQL Script
2. Add Admin Users

Execute the SQL Script
Each database has an individual script that adds tables, views and stored procedures used by the TAD processes. Below are the two scripts for this version.

• TAD Install V2.26 – Viewpoint.sql
• TAD Install V2.26 – KDS-HRIM.sql

1. Open SQL Server Management Studio and connect to your server.
2. Click File then Open and browse to where you saved the installation files.
3. Select one of the Viewpoint or KDS-HRIM installation scripts.
4. With the script opened, click the Execute button to start the installation.

The installation should take between 60-90 seconds depending on your server. When it finishes you should see a message saying TAD Installation Successful! If you do not see that message please contact support at support@transferalldata.com.

Add Admin Users
Use one of the scripts below to add the admin accounts. Additional users and permissions can be added using the TAD program.

• TAD Install V2.26 – Add Users Viewpoint.sql
• TAD Install V2.26 – Add Users KDS-HRIM.sql

1. In SQL Server Management Studio, click File then Open and browse to select the Add Users script for the same database you select in the previous step.
2. Replace ENTER USER in line 11 with the first admin account. Make sure to leave the single quotes around the account.
3. Click the Execute button to add the user.
4. Repeat the steps for any additional admin accounts.