Disconnecting Users in Azure SQL Geodatabase

Question

Hi, is there any workaround for dropping a locking connection to an Azure SQL Geodatabase?

I am aware that the Disconnect User command does not work. Is there an Azure Portal workaround perhaps or a SQL function that can be run?

"The geodatabase administrator cannot drop client connections from the Geodatabase Administration dialog box in ArcGIS Desktop clients."

Functionality differences for geodatabases in Azure SQL Database—ArcGIS Enterprise | ArcGIS Enterprise

Thanks for any thoughts.

Sam

JackChen2 · Answer

Hello Sam,

Here is the solution https://community.esri.com/message/888931-enterprise-geodatabase-in-azure-sql-database . Page 5.