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

Symptoms

Delete database login failed:

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

Cause

User does 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. Connect to the server via RDP;
2. Log into Microsoft SQL Server Management Studio;
3. Go to Security > Logins, right click on <DATABASE_NAME> and go to Properties;
4. Click on Server Roles Page;
5. Check the 'processadmin' role and click OK.

Or you can grant these permissions to that user:

CONFIG_TEXT: GRANT ALTER ANY CONNECTION TO <login>