Unable to activate or suspend reseller, customer, domain: Disable database user failed

Created:

2016-11-16 13:03:42 UTC

Modified:

2017-08-16 17:03:39 UTC

1

Was this article helpful?


Have more questions?

Submit a request

Unable to activate or suspend reseller, customer, domain: Disable database user failed

Applicable to:

  • Plesk 11.x for Windows
  • Plesk 12.0 for Windows
  • Plesk 12.5 for Windows

Symptoms

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.

In %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)

Cause

User is missing in MSSQL server or does not have access permission on database.

Resolution

Check in MSSQL Management Studio > Security > Logins if mentioned user exists on server.

If user exists

  1. Open MSSQL Management Studio > Security > Logins > <user_name> > Properties > User Mapping .

  2. Add access permissions on database that is assigned in Plesk for this user with desired server role. By default public role 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.
    OR
  • Create this user in MSSQL Management Studio > Security > Logins > New Login with SQL Server authentication and 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 .
Have more questions? Submit a request
Please sign in to leave a comment.