AnsweredAssumed Answered

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

Question asked by GeocloudAG on Sep 27, 2019
Latest reply on Feb 23, 2020 by newberry



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":
"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