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

Created:

2016-11-16 12:45:40 UTC

Modified:

2017-05-15 19:11:46 UTC

1

Was this article helpful?


Have more questions?

Submit a request

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

Applicable to:

  • Plesk 12.0 for Windows

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>
Have more questions? Submit a request
Please sign in to leave a comment.