SQL CobbleStone Database Installation

After setting up your SQL management studio as per CobbleStone® requirements in the SQL Server Install Article, run the DB_Installer executable that was sent from CobbleStone®. 

Keeping the name of the database as Contract Insight in the “Database” section below is recommended.

• Run create database Script (seen above)
• Run activation codes script (This script will be sent to you in a separate email as this changes due to company and license). 
• Very rarely the specific server’s name along with username and password could be needed.

Create Hangfire Database

Create an empty database for Hangfire. Most of the time it should be contractinsight_hangfire. If the customer chooses to name database differently then take the name they use and add _hangfire (Underscore hangfire)  

Set Up Permissions/User for SQL

Navigate to General Security, then logins.

For Windows authentication/trusted connection:

SQL Authentication :

If using SQL server authentication, please be sure that SQL server authentication is selected as in image above

• Uncheck “Enforce password policy” (this will also uncheck the other 2 and that is ok)
• Set default db to “ContractInsight” or whatever name your company has chosen for the database.

SQL Login User Mapping

1. Click on User Mapping in the top left under "Select a page"
   1. 
2. Find the database and check the box to select it
3. Default schema, click the “ … “ button and add dbo click “check name”, then “OK.”
4. Make sure db_owner is checked, click “OK”, then refresh. 
5. Repeat for the hangfire database. 

SQL Login Owned Schemas

1. Expand ContractInsight Database 
2. Expand security 
3. Expand Users and see user you created and double click. 
4. Go to owned schema page 
5. Select db_Owner and click “OK.” 
6. Repeat for the hangfire database 
   1.