AnsweredAssumed Answered

Error create geo database - CREATE DATABASE statement not allowed within multi-statement transaction

Question asked by smangroo@bot.com on Dec 3, 2019
Latest reply on Feb 19, 2020 by chakresh_sahu

Hi, 

 

We're getting this error when creating a geo database from ArcGIS Dekstop.

 

ArgGIS Server is 10.7.1

The DB is on Azure SQL Server (12.0.2000.8) 

 

[ERROR: Failed to create SQL Azure database geo_database (-51).

Error: Underlying DBMS error (-51).

Extended error code: (226)

[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]CREATE DATABASE statement not allowed within multi-statement transaction.

]

Failed to execute (CreateEnterpriseGeodatabase).

Failed at Tuesday, December 3, 2019 4:42:51 PM (Elapsed Time: 4.56 seconds)

 

We couldn't find anyone else experiencing this. Any ideas?

 

Thanks in advance.

Outcomes