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?
Solved! Go to Solution.
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..
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..