- 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
is in progress
will initiate a
on the table (which can take quite a while on a large table) to maintain DB consistency.
Login to the MS SQL server as
then use command
Ensure that user
used to connect to the MS SQL server has '
Process Admin (processadmin)
' SQL server role granted.
- Log into Microsoft SQL Server Management Studio
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 this permisson to that user
GRANT ALTER ANY CONNECTION TO <login>