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!
Solved! Go to 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 - 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.
Thank you very much!
@ManuelPerez - You are welcome. : )