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?