Article ID: 128200, created on Jan 30, 2016, last review on Jan 30, 2016

  • Applies to:
  • Plesk 12.5 for Windows
  • Plesk 12.0 for Windows
  • Plesk 11.5 for Windows


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) 


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

  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.
  • 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.

Search Words


suspend reseller


Error code: 1002. Error message: Disable database user failed:

Unable to suspend reseller

46a8e394d6fa13134808921036a34da8 56797cefb1efc9130f7c48a7d1db0f0c a914db3fdc7a53ddcfd1b2db8f5a1b9c 85a92ca67f2200d36506862eaa6ed6b8 bd7fc88cf1b01f097749ae6f87272128 8b661cab116c79dbe6c4ac5bbdf1c8cb a766cea0c28e23e978fa78ef81918ab8 ed7be2b984f9c27de1d2dc349dc19c6d

Email subscription for changes to this article
Save as PDF