Set transaction isolation level for MS SQL when used with Identity Manager

When you use MS SQL as database together with Smart ID Identity Manager the database transaction isolation level must be set to READ_COMMITTED_SNAPSHOT.

Set these commands on your database with, for example, SQL Server Management Studio:

1. Enable snapshot isolation:

   SQL

   {{ALTER DATABASE MyDatabase SET ALLOW_SNAPSHOT_ISOLATION ON }}
   

2. Replace the default READ COMMITTED behavior with SNAPSHOT:

   SQL

   {{ALTER DATABASE MyDatabase SET READ_COMMITTED_SNAPSHOT ON }}
   

3. You can verify the isolation with this command:

   SELECT name, is_read_committed_snapshot_on
   FROM sys.databases
   WHERE name = DB_NAME();
   

For more information, see:

• https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/sql/snapshot-isolation-in-sql-server

• https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-databases-transact-sql?view=sql-server-ver15