Disconnect User Permissions?

[TimHayes]

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 · Accepted solution]

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.

[TimHayes]

Thanks, your help was very useful. Problem solved.

[AsrujitSengupta]

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