Unable to activate or suspend reseller, customer or domain with error:
Error: Some of the selected domains or aliases were not activated. Error: Unable to activate the domain: Either the domain owner or their subscription is suspended.
%plesk_dir%\admin\logs\php_error.log the following error appears:
Disable database user failed: mssqlmng failed: Cannot drop the principal 'user', because it does not exist or you do not have permission. (Error code 1)
User is missing in MSSQL server or does not have access permission on database.
Check in MSSQL Management Studio > Security > Logins if mentioned user exists on server.
If user exists
Open MSSQL Management Studio > Security > Logins >
<user_name>> Properties > User Mapping.
- Add access permissions on database that is assigned in Plesk for this user with desired server role. By default
publicrole should be used.
If user does not exist
- Remove this user from Plesk > Subscriptions >
<subscription_name>> Websites & Domains > Databases > Users and then create it again if necessary using Add new database user button from the same location.
- Create this user in MSSQL Management Studio > Security > Logins > New Login with
SQL Server authenticationand assigning default database as in Plesk.
After that it will be necessary to update password for this user in Plesk > Subscriptions >
<subscription_name>> Websites & Domains > Databases > Users.