Article ID: 127480, created on Nov 19, 2015, last review on Nov 19, 2015

  • Applies to:
  • Plesk Automation 11.5

Symptoms

When trying to activate the domain in Customer Control Panel > Websites, it shows the error as below:

Error: The domain or website example.com cannot be activated because it was suspended by your hosting provider.

Under Operations > Tasks failed task with the following error can be found:

Disable database user failed: Cannot alter the role 'db_accessadmin', because it does not exist or you do not have permission.

Additionally the following error report can be found in /usr/local/psa/admin/bin/logs/panel.log:

2015-07-30T15:03:20+01:00 DEBUG (7)  [util_exec]: Start plesk agent: transaction=5639a0ae59bec810f1963850632ed434, transport=remote
2015-07-30T15:03:21+01:00 DEBUG (7)  [panel]: 0, script = mssqlmng, version = 1.0, args=--get-server-version --server=10.10.10.10\MSSQLSERVER2012 --login=mssql_admin --password=*******, stdin=, status=OK
2015-07-30T15:03:21+01:00 DEBUG (7)  [util_exec]: End: 5639a0ae59bec810f1963850632ed434
2015-07-30T15:03:21+01:00 DEBUG (7)  [util_exec]: Start plesk agent: transaction=39f6dab7cdc082be882d88128c0b901f, transport=remote
2015-07-30T15:03:21+01:00 DEBUG (7)  [panel]: 0, script = mssqlmng, version = 1.0, args=--access-user-disable --server=0.10.10.10\MSSQLSERVER2012 --login=mssql_admin --password=****** --database=DATABASE --user-login=DB_USER, stdin=, status=FAILED
[30-Jul-2015 15:03:21 Europe/London] PleskUtilException: Remote execution failed with code 1.

stdout:
Cannot alter the role 'db_accessadmin', because it does not exist or you do not have permission.

Cause

This issue caused by the fact that the user which used to to access the database server did not have permissions to manage reported database.

Resolution

TO fix this issue please do the following:

  1. Login to appropriate database server.

  2. login to SQL server management studio

  3. Go to * Server > Security > Logins > Administrator > right click Properties*

  4. Add required database under Users mapped to this login and add db_accessadmin under * Database role membership *

  5. Rerun failed task.

  6. Activate required webspace.

Search Words

suspended

The domain or website cannot be activated because it was suspended by your hosting provider

Remote execution failed with code 1.

33a70544d00d562bbc5b17762c4ed2b3 caea8340e2d186a540518d08602aa065 e0aff7830fa22f92062ee4db78133079

Email subscription for changes to this article
Save as PDF