topic Re: Missing permissions for removing and disconnecting locks/users from an SDE connection. in Geodatabase Questions

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

Yogesh_Chavan — Tue, 12 Nov 2024 12:25:29 GMT

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 — Tue, 12 Nov 2024 13:51:29 GMT

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.

MarceloMarques — Tue, 12 Nov 2024 16:10:43 GMT

Privileges for geodatabases in SQL Server

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 — Wed, 13 Nov 2024 13:01:18 GMT

Thank you @JakeSkinner !!

Yogesh_Chavan — Wed, 13 Nov 2024 13:01:34 GMT