Applicable to:
- Plesk 12.0 for Windows
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:
- Connect to the server via RDP;
- 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 grant these permissions to that user:
CONFIG_TEXT: GRANT ALTER ANY CONNECTION TO <login>
Additional information
User does not have permission to use kill statement
Comments
0 comments
Please sign in to leave a comment.