ArcGIS Pro: Active connections found during upgrade. Failed to enable database option

Error Message

In some instances, attempting to run the Enable Enterprise Geodatabase (Data Management) tool in ArcGIS Pro fails and returns the following error message:

Error:
Active connections found during upgrade ERROR: Failed to enable database option READ_COMMITTED_SNAPSHOT on SQL Server database (<Database_Name>).
Close all other connections to the database and try again

Cause

The Allow Snapshot Isolation and Is Read Committed Snapshot On SQL Server database options are set to False.

When running the Enable Enterprise Geodatabase (Data Management) tool, it uses the following default settings and creates the following database objects:

• It creates the Master Data File (MDF) and Log Data File (LDF) in the default SQL Server location on the server.
• It sets the Allow Snapshot Isolation and Is Read Committed Snapshot On SQL Server database options to True.
• It uses the default database file sizes defined for the SQL Server model database, or 500 MB for the MDF file and 125 MB for the LDF file, whichever is greater.
• If a geodatabase is created in a schema named "sde," the tool creates an sde database-authenticated login in the SQL Server instance, an sde user in the database and maps it to the sde login, an sde schema in the database, and grants the sde user privileges to create a geodatabase and drop connections to the SQL Server instance.
• It creates geodatabase objects inside the SQL Server instance.

If the tool fails to create or define the above database objects or settings, the process fails.

Solution or Workaround

Manually enable the database options in Microsoft SQL Server Management Studio

1. Launch Microsoft SQL Server Management Studio. When prompted, connect to the SQL Server instance using a sa or sde schema.
2. In the Object Explorer pane, expand the Databases folder, right-click the database returning the error, and select Properties.
3. In the Database Properties - <Database_Name> window, click Options.
4. For Allow Snapshot Isolation, click the drop-down arrow and change the value from False to True.
5. For Is Read Committed Snapshot On, click the drop-down arrow and change the value from False to True.
6. Click OK.

Change the database options using a new query in Microsoft SQL Server Management Studio

1. Launch Microsoft SQL Server Management Studio. When prompted, connect to the SQL Server instance using a sa or sde schema.
2. On the Microsoft SQL Server Management Studio ribbon, click New Query.
3. Specify the following query to set the Allow Snapshot Isolation and the Is Read Committed Snapshot On options to True.

ALTER DATABASE <Database_Name>
SET ALLOW_SNAPSHOT_ISOLATION ON;
GO
ALTER DATABASE <Database_Name>
SET READ_COMMITTED_SNAPSHOT ON;
GO

4. Click Execute.