AnsweredAssumed Answered

Issues creating a 10.5.1 Geodatabase on Sql Server 2016

Question asked by PrillLake on Oct 6, 2017
Latest reply on Feb 19, 2018 by groundworklondon

Having issues when creating a GDB in Sql Server 2016.  We're trying the method where our SQL dba creates an empty database or container, and the GDB admin (aka me) enables a geodatabase using DBO schema.

 

Some specifics:

My client:  Desktop 10.5.1

Sql Server Native Client:  version 9.00

Authorization file:  keycodes from an ArcServer 10.2.2 instance

Sql Server: version #13.0.4435.0

Database:  Read Committed & Allow Snapshot enabled. 

DB Security:  User matching my OS creds created, and given DB_Owner role.

 

 

Steps so far:

1. In Catalog, Added a Database Connection to the empty database

2. Right-clicked database connection file, and clicked Enable Geodatabase...

3. Process errored out.  Here's the contents of the sde_setup.log:

[Fri Oct 06 12:09:21 2017] Error creating VERSION table. (-51)
[Fri Oct 06 12:09:21 2017] DBMS error code: 2760
[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]The specified schema name "sde" either does not exist or you do not have permission to use it.

[Fri Oct 06 12:09:21 2017] SDE schema object install not completed.
[Fri Oct 06 12:09:21 2017] ERROR installing/upgrading ArcSDE, Error = -51

 

Any thoughts?

We are ready to have my login added as a SysAdmin on the Sql Server, if that is the best way to create a GDB with DBO schema.

Outcomes