Symptoms

Delete database login failed:

mssqlmng failed: User does not have permission to use the KILL statement

Cause

User do not have sufficient permissions or some transaction on <DATABASE_NAME> is in progress

Resolution

Note: The 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 KILL <SPID>

Ensure that user <login> used to connect to the MS SQL server has ' Process Admin (processadmin) ' SQL server role granted.

1. Log into Microsoft SQL Server Management Studio
2. Go to Security > Logins , right click on <DATABASE_NAME> and go to Properties
3. Click on Server Roles Page
4. Check the ' processadmin ' role and click OK.

Or you can grant this permisson to that user

GRANT ALTER ANY CONNECTION TO <login>