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