Is there a guide or process on how to create a DBO-schema Enterprise Geodatabase on Azure SQL Server?

[ManuelPerez]

Good Morning,

I've been looking for a process or guide on creating a dbo-owned schema Enterprise Geodatabase using an Azure SQL Server instance. When attempting to run the create enterprise geodatabase tool I get the following error:

Doing some further research, I followed the guide provided by Jack Chen for an SDE-owned schema and it worked successfully. I'd like to be able to do a DBO-owned schema on Azure as well without triggering these errors. Any advice would be appreciated, thanks!

[MarceloMarques · Accepted solution]

@ManuelPerez - the GP Tool "Create Enterprise Geodatabase" is not a supported workflow to create the ArcSDE Repository in Azure SQL Server, instead we use the "Enable Geodatabase" workflow. The DBO Geodatabase Schema is not supported in Azure SQL Server. We need to create the SDE user, grant the correct privileges to the SDE user and then use the "Enable Geodatabase" GP Tool to create the ArcSDE Repository in the Azure SQL Server database.

Enable Enterprise Geodatabase (Data Management)—ArcGIS Pro | Documentation

Create Enterprise Geodatabase (Data Management)—ArcGIS Pro | Documentation

ArcGIS Enterprise on Microsoft Azure 11.2 requirements for Microsoft Azure databases—ArcGIS Enterpri...

Requirements for using ArcGIS 11.2 and ArcGIS Pro 3.2 with databases in the cloud—ArcGIS Enterprise ...

I hope this helps.

[ManuelPerez]

Thank you very much!

[MarceloMarques]

@ManuelPerez  - You are welcome.  : )

[CZhang]

Hi I enabled the geodatabase successfully in ArcGIS Pro. Do you have a guide in creating user data schema in the dbo schema geodatabase in Azure SQL? I have so much trouble in creating db users and assign gis schema to the users. My user table created in ArcGIS Pro still under dbo.tablename. We want the data in geodatabase to be gisadmin.tablename.

[MarceloMarques]

@czhan - DBO schema geodatabases are not supported with Cloud databases like Azure SQL because there is no Active Directory to authenticate users.

You can learn the best practices to setup the Enterprise SQL Server Geodatabase if you read my database guidebook for Production Mapping in the link below, there you can also download my database template scripts for SQL Server.

Mapping and Charting Solutions (MCS) Enterprise Da... - Esri Community

• Guide Books ArcGIS Pro

• Database Connections Best Practices
• Database Template Scripts