Missing permissions for removing and disconnecting locks/users from an SDE connection.

[Yogesh_Chavan]

We have SQL Server 2022 and in ArcGIS Pro 3.3 when we try to disconnect a user from the connection, it fails with the below error:

Through some research we got to know that DB owner should have View_Definition permission which we granted. Issue is still observed.

What else are we missing here?

[JakeSkinner · Accepted solution]

Hi @Yogesh_Chavan, is your geodatabase administrator a user named sde or a login that is mapped to the dbo user in the database that contains the geodatabase?  The user must also be added to the processadmin server role to disconnect users.

[Yogesh_Chavan]

Thank you @JakeSkinner !!

[MarceloMarques]

@Yogesh_Chavan 

Privileges for geodatabases in SQL Server

https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/manage-sql-server/privileges-sqlserv...

For best practices on how to setup a production enterprise geodatabase in SQL Server read my database guide books and database template scripts for Production Mapping in my community.esri.com blog.
Mapping and Charting Solutions (MCS) Enterprise Databases Best Practices

[Yogesh_Chavan]

Thank you @MarceloMarques .