Unable to activate domain in Plesk. Error "Disable database user failed".

Unable to activate domain in Plesk. Error "Disable database user failed".

If you are trying to activate any reseller or customer or domain or sub-domain and you are getting this like error:
"Disable database user failed: mssqlmng failed: Cannot drop the principal 'username', because it does not exist or you do not have permission.(Error code 1)"

Why this error occurs?
This error occurs when the user is missing in MSSQL server or does not have access permission on the database.

How to resolve this issue?

1). To resolve this issue we have to login to windows server and then open MSSQL Management Studio.

2). Open Security >> Logins >> Users
plesk1.png

3). Now check for the user whether it exists or not.

If user exists in the list, then right click on the user >> Properties >> User Mapping
Now, add permission on the database that is assigned to this user in Plesk control panel with the server role. By deafult, it is set to "Public".
plesk2.png

If user does not exist in the list, then remove the user from the database users in Plesk and recreate it again through:
Plesk >> "Subscriptions" >> select desired subscription >> "Websites & Domains" >> "Databses" >> "Users"
Author
bhawanisingh
Views
2,145
First release
Last update
Rating
0.00 star(s) 0 ratings
Top