topic Re: Disconnect User Permissions? in Data Management Questions

Disconnect User Permissions?

TimHayes — Tue, 16 Sep 2014 15:58:33 GMT

I have an ArcGIS for Server 10.2.2 Enterprise Geodatabase in SQL Server 2008 R2. It was set up with Database Permissions in SQL Server, not Windows/OS. I am the Database Administrator.

I need to disconnect a user from our Enterprise Geodatabase and when I try to do so it says I do not have the permissions.

In ArcCatalog, I went to my Enterprise Geodatabase - Administration - Administer Geodatabase - Connections. I chose the user to disconnect but then a message pops up saying I do not have the permissions to do so.

What additional permissions do I need to set in SQL Server Management Studio to be able to disconnect a user from our Enterprise Geodatabase?

Re: Disconnect User Permissions?

AsrujitSengupta — Tue, 16 Sep 2014 17:25:40 GMT

Removing connections from a geodatabase in SQL Server:

ArcGIS Help (10.2, 10.2.1, and 10.2.2)

The geodatabase administrator in SQL Server:

ArcGIS Help (10.2, 10.2.1, and 10.2.2)

You will have to grant that user the processadmin fixed server role to grant it sufficient permissions to disconnect other connections.

Re: Disconnect User Permissions?

TimHayes — Sun, 28 Sep 2014 04:36:26 GMT

Thanks, your help was very useful. Problem solved.

Re: Disconnect User Permissions?

AsrujitSengupta — Sun, 28 Sep 2014 08:03:28 GMT

Great!! Mark the thread as Answered or the reply helpful, if possible.