How to give the connector access to SQL Server

Where you are looking to setup the connection between your Glide system and your CCH system you shall need to do the following on the SQL Server that hosts CCH.

This tutorial assumes that you will host the connector on the SQL Server machine. If you decide to host the connector on a different machine then further configuration may be necessary.

Step 1 -> To create the user account on SQL Server follow these steps:

1. Open SQL Server Management Studio.
2. Connect to the CCH SQL Server database instance.
3. Open the Security folder.
4. Right-click on the Logins folder and select New Login.
5. Select SQL Server authentication.
6. Enter a login name and password. You will later need to enter these into the connector's configuration file.
7. Untick Enforce password expiration (this would periodically break the integration).
8. Click OK to create the account.

Step 2 -> Create the glideInt database:

1. Open SQL Server Management Studio.
2. Execute the script found in the CCH Connector package that you will have been provided with. The filename is "Setup_CreateGlideIntDatabase.sql".

Step 3 -> Once you have created the user account and glideInt database you need to assign permissions following these steps:

1. Open SQL Server Management Studio.
2. Open the Security folder.
3. Drill into the new user created for Glide.
4. Select the User mapping page.
5. Tick the CCH database that will typically be called "Central".
6. Under database role membership tick db_datareader.
7. Click OK to save the changes.
8. Repeat steps 5, 6 and 7 for the glideInt database. On this database the Glide user should also have the db_datawriter role.

Step 4 -> Create the database triggers:

1. Open SQL Server Management Studio.
2. Execute the script to create the database triggers. This script can be found in the CCH Connector package that you will have been provided with and is called "Setup_CreateTriggers.sql".

The triggers will fire when a new client is added to CCH or when an existing client is updated. They will add a new row to the glideInt database table which is then interrogated by the connector every 15 minutes.

Once you have completed these steps return to continue the connector setup process.