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

3616
1
12-03-2019 02:13 PM
ShawnMangroo
New Contributor

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.

0 Kudos
1 Reply
chakreshsahu
New Contributor III

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 = 'xxx’

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.