- Plesk 12.0 for Windows
Delete database login failed:
CONFIG_TEXT: mssqlmng failed: User does not have permission to use the KILL statement
User does not have sufficient permissions or some transaction on
<DATABASE_NAME> is in progress.
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
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 you can grant these permissions to that user:
CONFIG_TEXT: GRANT ALTER ANY CONNECTION TO <login>