AnsweredAssumed Answered

Creating a geodatabase on a Multiple instance SQL Server

Question asked by BISYSTEMS on Apr 13, 2015
Latest reply on Jun 8, 2015 by BISYSTEMS

Hi All,

 

Some background

Esri Server

Windows 2012 R2 Standard SP1

ArcMap 10.3.0.4322

SQL Server Native Client 2008 R2 10.50.4000.0 (SP2)

 

SQL Server Database

Windows 2008 R2 Standard SP2

SQL Server 2008 R2 10.50.4000.0 (SP2)

Multiple instance including

DEVELOPMENT

UAT

PRODUCTION

 

E.g. <server>\DEVELOPMENT or <server>,port to connect

 

I've attempted to create a geodatabase on this multi instance SQL Server and failed,

I spun up a single instance SQL server on a VM and can successfully create a geodatabase.

 

The error I get is as follows when it attempts to create the GDB_ITEM table at the definition column which is the first XML datatype.

 

[Tue Apr 14 09:30:41 2015] Successfully created GDB_Tables_Last_Modified table...

[Tue Apr 14 09:30:41 2015] Error creating  GDB_Items table...

[Tue Apr 14 09:30:41 2015] ERROR Creating Geodatabase tables

, Error = -511

,EXT_Error = 24000

,EXT_ERROR1 = [Microsoft][SQL Server Native Client 10.0]Invalid cursor state

,EXT_ERROR2 =

 

Has anyone else come across this issue?  Did you manage to get passed the error?

Any tips, tricks, that I can use to dig deeper into this issue?

 

Cheers

Peter

Outcomes