Article ID: 123647, created on Nov 23, 2014, last review on Nov 23, 2014

  • Applies to:
  • Plesk 12.0 for Windows


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


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


Search Words

User does not have permission to use the KILL statement

mssqlmng failed

ed7be2b984f9c27de1d2dc349dc19c6d 56797cefb1efc9130f7c48a7d1db0f0c a914db3fdc7a53ddcfd1b2db8f5a1b9c 85a92ca67f2200d36506862eaa6ed6b8 a766cea0c28e23e978fa78ef81918ab8

Email subscription for changes to this article
Save as PDF