Visit Nexus to get an overview of Nexus' solutions, read customer cases, access the latest news, and more.


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:

    {{ALTER DATABASE MyDatabase SET ALLOW_SNAPSHOT_ISOLATION ON }}
  2. Replace the default READ COMMITTED behavior with SNAPSHOT:

    {{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 these articles: