Let us learn more about the error Unable to activate domain or import MSSQL dump in Plesk. With the help of our MSSQL support services at Bobcares, we will learn more about the error.

Error: Unable to activate domain or import MSSQL dump in Plesk: Symptoms

With one of the issues listed below, we are unable to activate/deactivate a domain or import an MSSQL dump.

• Error: Unable to activate/deactivate domain: User or role 'db_user' does not exist in this database.
at (VADOConnection::execute line 90)
at Disable user db_user in MSSQL database database_name on host 203.0.113.2\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)Error: Some of the selected subscriptions were not activated.
Enable database user failed: mssqlmng failed: User or role 'db_user' does not exist in this database. at (VADOConnection::execute line 78) at execute console command --access-user-enable(vconsoleapp::start line 100) at execute "C:\Program Files (x86)\Parallels\Plesk\admin\bin\mssqlmng.exe" --access-user-enable "--server=localhost" "--login=sa" "--password=*" "--database=database_name " "--user-login=db_user"(vconsoleapp::run line 117) (Error code 1)
• After hitting the OK button, the same problem will open up in Domains > example.com > Databases > User Management > db user.

These are some of the major symptoms of the error and we can now move on and learn more about the causes and the solutions for the error.

Error: cannot activate domain or import MSSQL dump in Plesk: Causes and resolution

The database user is either not in map to the domain’s database or is not present in MSSQL Server.

Solution for the error:

Follow the steps given below to resolve the Plesk cannot activate domain or import MSSQL error:

1. RDP is used to connect to the server.
2. In SQL Server Management Studio, go to Security > Logins > db user > Properties > User Mapping and map the database to the user.

[Need assistance with similar queries? We are here to help]

Conclusion

To sum up we have now seen the symptoms, causes and the resolution for the error cannot activate domain or import MSSQL dump in Plesk.

With the support of our MSSQL support services at Bobcares we have now gone through the steps necessary to remove the error easily.