topic Re: Azure SQL/PaaS - user 'sde' can't kill connections in Cloud Computing Questions

Azure SQL/PaaS - user 'sde' can't kill connections

GeocloudAG — Fri, 27 Sep 2019 14:44:58 GMT

Hi,

We're building a new GIS environment on Azure using Azure SQL databases - PaaS (Platform-as-a-Service).

Now we have found that the user "sde" has no rights to disconnect open connections (arcpy.DisconnectUser (workspace, "ALL")).

According to the online documentation, the user "sde" needs the role "processadmin":
https://pro.arcgis.com/de/pro-app/help/data/geodatabases/manage-sql-server/manage-connections-sqlserver.htm
"To disconnect users, they must be members of the specified processadmin server role."

However, there are no server roles in Azure SQL (PaaS).

Can anybody tell me how I can kill open connections in Azure (for example, for a full compress)?

Thanks, Andrea

Re: Azure SQL/PaaS - user 'sde' can't kill connections

ChristianWells — Fri, 27 Sep 2019 17:57:53 GMT

Thank you for reaching out, there are some differences with an Azure SQL database and a typical SQL Server database. One of those functional differences is the ability to drop users from the Geodatabase Administration window.

Functionality differences for geodatabases in Azure SQL Database

https://enterprise.arcgis.com/en/server/latest/cloud/azure/functionality-geodatabase-azure-sql-database.htm

Re: Azure SQL/PaaS - user 'sde' can't kill connections

JackChen2 — Sun, 23 Feb 2020 17:34:51 GMT

Hey Andrea,

Here is the solution https://community.esri.com/thread/243141-enterprise-geodatabase-in-azure-sql-database . On page 5.