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.