I am using ArcGIS 10.2.2 and SQL Server 2008 R2.
I have several Locks from users on our SQL Server Enterprise Geodatabase that I need to disconnect.
I am using Database Authentication, not OS Authentication.
Our database is under a SQL Server Instance managed by our System Administrator (not in GIS, but our IT Group).
At the Database Level Role, I am the db_owner. I have no Server Level Role.
Is there a way to disconnect a Lock at the Database Level Role? or do I need to have our Sys Admin person add SDE to the processadmin role under Server Level Roles?
SDE (geodatabase administrator) typically has the "power" to disconnect locks in clients. You can read more about it here - http://desktop.arcgis.com/en/arcmap/10.3/manage-data/gdbs-in-postgresql/manage-geodatabase-locks.htm