Issues creating Enterprise Geodatabase

[KyleLawhorn]

Hi,

I hope this is the best spot to ask this question, if not, please tell me where to put it.

I'm currently trying to create a new enterprise geodatabase for my company, unfortunately I have limited experience with this side of Arc and have fallen into this role.  At the present time, I have a server running Windows Server 2012, this server is running 2 virtual servers (also on Server 2012) via Hyper-V.  One of the servers is SDE SERVER with Arc 10.5 installed, the other is SQL SERVER and runs Microsoft SQL 2012. 

I'm trying to use the Create Enterprise Geodatabase Tool via Arc Catalog on my local computer.  It sees the SQL Server, and the database "SDE" that I created on it.  However, when I run the tool I'm greeted with the following error:

Start Time: Mon Apr 15 09:00:53 2019
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.
Successfully enabled database option ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT.
Created geodatabase tables and stored procedures.
The geodatabase system table could not be created.GDB_Items : Error (-51)
See the setup log in the following location for additional error information:
C:\Users\KSLAWH~1\AppData\Local\Temp\sde_setup.log
Could not create geodatabase schema.
Failed to execute (CreateEnterpriseGeodatabase).
Failed at Mon Apr 15 09:01:04 2019 (Elapsed Time: 10.44 seconds)

Here is the log:

[Mon Apr 15 09:00:54 2019] VERSION table created...
[Mon Apr 15 09:00:54 2019] SPATIAL_REFERENCES table being created...
[Mon Apr 15 09:00:54 2019] SPATIAL_REFERENCES table created...
[Mon Apr 15 09:00:54 2019] GEOMETRY_COLUMNS table being created...
[Mon Apr 15 09:00:55 2019] GEOMETRY_COLUMNS table created...
[Mon Apr 15 09:00:55 2019] LAYERS table being created...
[Mon Apr 15 09:00:55 2019] LAYERS table created...
[Mon Apr 15 09:00:55 2019] METADATA table being created...
[Mon Apr 15 09:00:55 2019] METADATA table created...
[Mon Apr 15 09:00:55 2019] RASTER_COLUMNS table being created...
[Mon Apr 15 09:00:55 2019] RASTER_COLUMNS table created...
[Mon Apr 15 09:00:55 2019] TABLE_REGISTRY table being created...
[Mon Apr 15 09:00:55 2019] TABLE_REGISTRY table created...
[Mon Apr 15 09:00:55 2019] STATES table being created...
[Mon Apr 15 09:00:55 2019] STATES table created...
[Mon Apr 15 09:00:55 2019] VERSIONS table being created...
[Mon Apr 15 09:00:55 2019] VERSIONS table created...
[Mon Apr 15 09:00:55 2019] MVTABLES_MODIFIED table being created...
[Mon Apr 15 09:00:55 2019] MVTABLES_MODIFIED table created...
[Mon Apr 15 09:00:55 2019] STATE_LINEAGES table being created...
[Mon Apr 15 09:00:55 2019] STATE_LINEAGES table created...
[Mon Apr 15 09:00:55 2019] LOCATORS table being created...
[Mon Apr 15 09:00:55 2019] LOCATORS table created...
[Mon Apr 15 09:00:55 2019] XML tables being created...
[Mon Apr 15 09:00:55 2019] XML tables created...
[Mon Apr 15 09:00:55 2019] COLUMN_REGISTRY table being created...
[Mon Apr 15 09:00:55 2019] COLUMN_REGISTRY table created...
[Mon Apr 15 09:00:55 2019] ARCHIVES table being created...
[Mon Apr 15 09:00:55 2019] ARCHIVES table created...
[Mon Apr 15 09:00:55 2019] LAYER_STATS table being created...
[Mon Apr 15 09:00:55 2019] LAYER_STATS table created...
[Mon Apr 15 09:00:55 2019] BRANCHES table being created...
[Mon Apr 15 09:00:55 2019] BRANCHES table created...
[Mon Apr 15 09:00:55 2019] BRANCH_TABLES_MODIFIED table being created...
[Mon Apr 15 09:00:55 2019] BRANCH_TABLES_MODIFIED table created...
[Mon Apr 15 09:00:55 2019] BRANCHES table being created...
[Mon Apr 15 09:00:55 2019] MULTIBRANCH_TABLES table created...
[Mon Apr 15 09:00:55 2019] LOGFILE_POOL tables being created...
[Mon Apr 15 09:00:55 2019] LOGFILE_POOL tables created...
[Mon Apr 15 09:00:55 2019] DBTUNE table being created...
[Mon Apr 15 09:00:55 2019] DBTUNE table created...
[Mon Apr 15 09:00:55 2019] SERVER_CONFIG tables being created...
[Mon Apr 15 09:00:55 2019] SERVER_CONFIG tables created...
[Mon Apr 15 09:00:55 2019] DBMS stored procedures being created or updated...
[Mon Apr 15 09:00:57 2019] DBMS stored procedures created or updated...
[Mon Apr 15 09:00:58 2019]
Successfully installed ArcSde.

[Mon Apr 15 09:00:59 2019] Successfully created  GDB_Tables_Last_Modified table...
[Mon Apr 15 09:01:00 2019] Error creating  GDB_Items table...
[Mon Apr 15 09:01:00 2019] ERROR Creating Geodatabase tables
, Error = -511
,EXT_Error = 0
,EXT_ERROR1 =
,EXT_ERROR2 =
,

Any help is much appreciated.  I wouldn't say I'm lost, but I definitely need some guidance. 
Thanks for the help.

[Robert_LeClair]

For ArcGIS 10.5, MS SQL Server 2012 SP3 (64-bit) is the supported RDBMS so I would recommend checking that AND seeing if the correct SQL Server client in installed.  For SQL Server 2012, the supported clients may be found here.

[KyleLawhorn]

I'm downloading SP3 now and I'll check to see if that works.  I currently have the SQL 2012 Native Client installed on my local machine.  Is that the correct configuration?

Thank you for your help.

[Robert_LeClair · Accepted solution]

I believe so - once SP3 is installed, try to create an enterprise geodatabase again.  Also confirm you have MS ODBC Driver for SQL client installed too (11, 13, or 13.1).

[Robert_LeClair]

Kyle - wanted to check in to see if you were able to create a new enterprise geodatabase after the recent updates.

[KyleLawhorn]

Yes!  It worked perfectly.  Thanks so much for your help, I really appreciate it.

[Robert_LeClair]

Great to hear!  If you would be able to close the thread by marking the response as correct/answered, I'd appreciate it - all the best!

[KyleLawhorn]

Robert, I've encountered another issue.  It was working yesterday, but as of lunch time today I'm unable to get a connection to the database in Arc Catalog.  I'm greeted with the following error:

Failed to connect to the specified server.  Do you want to continue?  This release of the GeoDatabase is either invalid or out of date.  DBMS table not found [42S02:[Microsoft[ODBC Driver 13 for SQL Server][SQL Server] Invalid object name 'SpartanSDE.sde.GDB_Release'.][SpartanSDE.sde.GDB_Release]

If I try to create a new enterprise geodatabase I get the same error that I got when I made this thread initially.

[Robert_LeClair]

Kyle - so the error message only appears while in ArcCatalog but not ArcMap, correct?  And to confirm, you're using ArcMap 10.5, SQL Server 2012 (SP 3) 64-bit, installed the SQL client and MS ODBC Driver for SQL client 13?

[KyleLawhorn]

I have not tried creating the geodatabase in Arc Map. 

I'm using Arc 10.5.1 across the entire suite of products.

The SQL Server is running SQL 2012 SP3.  My client machine has Arc Catalog 10.5.1 the SQL Native Client, and the MS ODBC Driver 13.