Enable Enterprise Geodatabase tool tries to use SDE schema when it should use DBO

3760
1
Jump to solution
02-25-2020 02:54 AM
Tim_StærkFendrich1
New Contributor II

Hi

I'm trying to enable an Enterprise Geodatabase in SQL Server 2016. The database is created and I have a windows account with DB_OWNER rights on the database. The login of the windows accounts is mapped to the username (domain\loginname) and the dbo schema in the database .

I have created a connection file with Operating System Authentification selected, but when I run the Enable Enterprise Geodatabase tool in ArcGIS Pro 2.5 it fails right after setting the snapshot-states with the error below:

Validated authorization file.
User has required privileges for geodatabase setup.
XML support is enabled for the database instance.
Successfully enabled database option ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT.
[Underlying DBMS error]
See the setup log in the following location for additional error information:
C:\Users\<user>\AppData\Local\Temp\sde_setup.log
Could not create  geodatabase tables and stored procedures.
Failed to execute (EnableEnterpriseGeodatabase).

In the sde_setup.log:

[10:47:58.535] Error creating VERSION table. (-51)
[10:47:58.535] DBMS error code: 2760
[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The specified schema
name "sde" either does not exist or you do not have permission to use it.




[10:47:58.535] SDE schema object install not completed.
[10:47:58.538] ERROR installing/upgrading ArcSDE, Error = -51

And that is true. I want an DBO schema not a SDE schema.

But how do I persuade the tool to create the DBO schema instead?

Is there something wrong with the user mapping? In another environment with an SQLEXPRESS instance I can enable the geodatabase but in that environment my windows user is mapped not only to the dbo-schema but also to the dbo user in the database - is that the way to go?

0 Kudos
1 Solution

Accepted Solutions
Asrujit_SenGupta
MVP Regular Contributor
1 Reply
Asrujit_SenGupta
MVP Regular Contributor

Check these links:

Issues creating a 10.5.1 Geodatabase on Sql Server 2016 

https://community.esri.com/thread/196493-problem-enabling-an-enterprise-gdb 

Grant SYSADMIN to the login of the Windows Account and then execute the tool..