AnsweredAssumed Answered

Disconnect Geodatabase Lock

Question asked by THayes on Sep 2, 2016
Latest reply on Sep 7, 2016 by THayes

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?

Outcomes