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 (below) to create the new database.

1---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. You will need to request this from your Glide Account manager as the script may be customised to suit your circumstances.

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.

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us