Delete database login failed:
mssqlmng failed: User does not have permission to use the KILL statement
User do not have sufficient permissions or some transaction on
<DATABASE_NAME> is in progress
KILL will initiate a
ROLLBACK on the table (which can take quite a while on a large table) to maintain DB consistency.
Login to the MS SQL server as
sa user, execute
sp_who then use command
Ensure that user
<login> used to connect to the MS SQL server has '
Process Admin (processadmin)' SQL server role granted.
- Log into Microsoft SQL Server Management Studio
- Go to Security > Logins, right click on
<DATABASE_NAME>and go to Properties
- Click on Server Roles Page
- Check the '
processadmin' role and click OK.
Or you can grant this permisson to that user
GRANT ALTER ANY CONNECTION TO <login>