Underlying DBMS errorFail to enable database option ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT

6506
12
Jump to solution
04-18-2018 06:04 AM
EwaWalewska
New Contributor II

I'm getting this type of error when try to Enable Enterprise Geodatabase:

Underlying DBMS errorFail to enable database option ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT.
Failed to execute (EnableEnterpriseGeodatabase).

But both option: 

- Allow Snapshot Issolation

- Is Read Committed Shanpshot On 

are set to True.

What else can be wrong?

0 Kudos
12 Replies
AhmadSALEH1
Occasional Contributor III

I dont have a "-" and I get get this error !

by Anonymous User
Not applicable

Observed the same issue with the Database name with DOT ".", Once I replace the database name with "_" GP tool is working fine and enterprise Geodatabase created and configured.

0 Kudos
AvinashPatel
New Contributor II

I have observed the same issue with Database Name, Once the DB name is removed with the "-" GP tool works fine.

AvinashPatel_0-1658393858977.png

ALTER DATABASE "DB_Name" SET READ_COMMITTED_SNAPSHOT ON;
ALTER DATABASE "DB_Name" SET ALLOW_SNAPSHOT_ISOLATION ON ;

 

With new name

AvinashPatel_1-1658393917872.png

 

0 Kudos