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

ShawnMangroo

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.

chakreshsahu

Hi Shawn,

For creating SDE Schema based Enterprise Geodatabase in Azure SQL database use following steps. These steps are given for Microsoft Azure SQL Database Managed Instance.

1. Connect Azure SQL Server Instance thorough Microsoft SQL Server Management Studio (SSMS).

2. Create SDE Login at Instance Level

CREATE LOGIN sde WITH PASSWORD = 'xyz’

3. Create SDE user on master database

CREATE USER sde FROM LOGIN sde

4.  Add login to the loginmanager role

ALTER ROLE loginmanager ADD MEMBER sde;

5. Create a database in Azure SQL Server

6. Create a user SDE on newly SQL Server database.

CREATE USER sde FROM LOGIN sde

7. Open ArcCatalog and click Create Enterprise Geodatabase tool to create enterprise Geodatabase.

8. Upon successful completion of enterprise geodatabase tool, Create a connection to Azure SQL database through SDE user.

Details steps are given in attached document.

Create SDE Schema Enterprise Geodatabase in Azure SQL database.pdf