SQL CobbleStone Database Installation
  • 25 Jan 2024
  • 1 Minute to read
  • Dark

SQL CobbleStone Database Installation

  • Dark

Article summary

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 Package to create a new Database

  • 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:

Login and Setup Permissions/User for SQL

* If using Windows Authentication password can NEVER EXPIRE in active directory or wherever it is stored. It is recommended that it is a service account whose password never expires. If using Windows authentication, please be sure that windows authentication is selected as in image above

SQL Authentication :

Setup SQL Server 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. Setting up SQL Login User Mapping
  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. Setup  SQL Login Owned Schemas

Was this article helpful?