Installation and Configuration Guide

Back Next

Configure the Microsoft SQL Server Database

If you install

Data Integration Hub

repositories on a Microsoft SQL Server database, enable the

READ_COMMITTED_SNAPSHOT

database option. If you install the Dashboard and Reports component, enable the

READ_COMMITTED_SNAPSHOT

option on the operational data store as well.

If you use Microsoft SQL Server 2012, you can set the option

Is read committed snapshot on

in Microsoft SQL Server Management Studio to

true

instead.

Open an SQL query for the database server with rights to set database options.

Run the following SQL statements:

ALTER DATABASE [<database_name>] SET SINGLE_USER WITH ROLLBACK IMMEDIATE

Run the following SQL query:

ALTER DATABASE <database_name> SET READ_COMMITTED_SNAPSHOT ON

To verify that this option is set, run the following SQL query:

SELECT is_read_committed_snapshot_on FROM sys.databases WHERE name = '<database_name>'

If the option is set, the query returns the value 1. If the option is not set, the query returns the value 0.

Run the following SQL statement to forcefully disconnect all users from the system:

ALTER DATABASE [<database_name>] SET MULTI_USER