Attempting to configure Active Roles against a new database server fails with the ERROR: "Operation cannot be performed on database in mirroring/availability group" (4377349)

Attempting to configure Active Roles against a blank database on a Microsoft SQL Server fails with the following error:

The operation cannot be performed on database 'database' because it is involved in a database mirroring session or an availability group. Some operations are not allowed on a database that is participating in a database mirroring session or in an availability group.

This error is displayed if the SQL Server is either in an Availability Group OR mirrored, and when READ_COMMITTED_SNAPSHOT on that SQL Server is OFF.

The READ_COMMITTED_SNAPSHOT is a database option that changes the behavior of the transactions running under the READ COMMITTED isolation level. By default, it is set OFF in SQL Server databases. In this case, locking is used to eliminate dirty reads in the READ COMMITTED transaction isolation level. When it is turned to ON, row versioning is used instead of locking.

WORKAROUND

Change the Microsoft SQL Server configuration and set READ_COMMITTED_SNAPSHOT to ON.

This can be done by executing the following on the SQL Server:

ALTER DATABASE database_name SET READ_COMMITTED_SNAPSHOT ON

If you have any questions or concerns about READ_COMMITTED_SNAPSHOT, please contact your DBA team or Microsoft.