Disconnect User Permissions?

THayes2000

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?

AsrujitSengupta

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.