topic Underlying DBMS errorFail to enable database option ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT in Geodatabase Questions

Underlying DBMS errorFail to enable database option ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT

EwaWalewska — Wed, 18 Apr 2018 13:04:27 GMT

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?

Re: Underlying DBMS errorFail to enable database option ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT

Asrujit_SenGupta — Wed, 18 Apr 2018 13:09:53 GMT

Did you turn those settings to ON and then try the Enable Enterprise Geodatabase? Or tried to enable first, encountered the error, changed settings and then trying to enable again?

Close the ArcCatalog, reopen and try again...

Re: Underlying DBMS errorFail to enable database option ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT

EwaWalewska — Wed, 18 Apr 2018 13:19:54 GMT

1) First I set:

- Allow Snapshot Issolation

- Is Read Committed Shanpshot On

to ON/True

2) Then I runned Enable Enterprise Geodatabase tool

3) ArcCatalog was closed and reopened many times, I was testing this for quite long time (I created also new database to check if maybe there is something was wrong with previous one, but still I get this error).

Re: Underlying DBMS errorFail to enable database option ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT

Asrujit_SenGupta — Wed, 18 Apr 2018 14:04:07 GMT

You are trying to create a DBO schema or the SDE schema geodatabase?
Have you tried the "Create Enterprise Geodatabase" tool?

Re: Underlying DBMS errorFail to enable database option ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT

EwaWalewska — Wed, 18 Apr 2018 14:28:40 GMT

1) SDE (user: sde, default schema: sde)

2) Create Enterprise Geodatabase result is:

User has privileges required to create database objects.
Database already exists.
Validated authorization file.
User has required privileges for geodatabase setup.
XML support is enabled for the database instance.
Underlying DBMS errorFail to enable database option ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT.
Failed to execute (CreateEnterpriseGeodatabase).

Re: Underlying DBMS errorFail to enable database option ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT

Asrujit_SenGupta — Wed, 18 Apr 2018 16:32:49 GMT

Well, I'll suggest trying to create a DBO schema gdb and check

Also, grant SDE the elevated permissions to alter those settings and try...

Re: Underlying DBMS errorFail to enable database option ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT

EwaWalewska — Thu, 19 Apr 2018 09:48:59 GMT

I created new database where SDE user is db_owner, and I set in user mapping => user:dbo, schema: dbo and ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT are both set for True for this database.

Error is the same:

Validated authorization file.
User has required privileges for geodatabase setup.
XML support is enabled for the database instance.
Underlying DBMS errorFail to enable database option ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT.
Failed to execute (EnableEnterpriseGeodatabase).

Re: Underlying DBMS errorFail to enable database option ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT

RexRobichaux2 — Thu, 19 Apr 2018 11:47:40 GMT

Hello Ewa- what version of version of SQL Server and ArcGIS DT / Pro are you using to run the Enable GDB tool from? Have any privileges been revoked from any user and / or the public role? Lastly, can you check the sde_setup.log file which should be located in the C:\Users\<username>\AppData\Local|\Temp directory.

Re: Underlying DBMS errorFail to enable database option ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT

EwaWalewska — Fri, 20 Apr 2018 11:26:28 GMT

We found the cause of having this problem.

Name of database has '-' sign!!! On different environment it works just fine!!

And there was no information that he cannot connect to database!!!

When I change the name, it just start working!

Re: Underlying DBMS errorFail to enable database option ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT

BrettTatum — Fri, 06 Jul 2018 14:32:20 GMT

It was the dash for me as well!!

I tried different versions of SQL (2012, 2017), Arc (10.4.1 and 10.6), and gave sde db_owner to test. Nothing worked until I removed the dash!!

Re: Underlying DBMS errorFail to enable database option ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT

AhmadSALEH1 — Mon, 03 Dec 2018 20:18:41 GMT

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

Re: Underlying DBMS errorFail to enable database option ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT

Anonymous User — Mon, 26 Jul 2021 08:47:07 GMT

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.

Re: Underlying DBMS errorFail to enable database option ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT

AvinashPatel — Thu, 21 Jul 2022 08:58:51 GMT

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

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

With new name