Unable to activate/deactivate domain: User or role does not exist in this database

Created:

2016-11-16 12:53:19 UTC

Modified:

2017-04-24 11:21:48 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Unable to activate/deactivate domain: User or role does not exist in this database

Applicable to:

  • Plesk 10.4 for Windows
  • Plesk 12.5 for Linux
  • Plesk 11.0 for Windows
  • Plesk 11.5 for Windows
  • Plesk 12.0 for Windows
  • Plesk 12.5 for Windows
  • Plesk 9.x and below for Windows

Symptoms

Unable to activate/deactivate domain, the following error appears:

Error: Unable to activate/deactivate domain: User or role 'testuser' does not exist in this database.
at (VADOConnection::execute line 90)
at Disable user testuser in MSSQL database mydatabase on host 123.123.123.123\\SQLEXPRESS.(domainmng::alter_mssql_users line 730)
at Turn off dbusers for domain domain.tld(domainmng::db_users_on_off line 486)
at (domainmng::db_users_on_off line 487)
at Turn off domain domain.tld (state=1)(domainmng::turnDomain line 120)

Or

Error: Some of the selected subscriptions were not activated. 
Enable database user failed: mssqlmng failed: User or role 'testuser' does not exist in this database. at (VADOConnection::execute line 78) at execute console command --access-user-enable(vconsoleapp::start line 100) at execute "D:\\Program Files (x86)\\Parallels\\Plesk\\admin\\bin\\mssqlmng.exe" --access-user-enable "--server=localhost" "--login=sa" "--password=*" "--database=mydatabase" "--user-login=testuser"(vconsoleapp::run line 117) (Error code 1)

Cause

Database User (in particular case, it is "testuser") is not mapped to domain database mydatabase or absent in MSSQL Server .

Resolution

  1. Make sure that the mentioned database user exists in MSSQL Server , it can be checked with SQL Management Studio > Security > Logins , for example.

  2. Assign user to the database directly in SQL Management Studio or other MSSQL Server Manager.

Have more questions? Submit a request
Please sign in to leave a comment.