Unable to activate area or import MSSQL dump in Plesk

Allow us to study extra concerning the error Unable to activate area or import MSSQL dump in Plesk. With the assistance of our MSSQL assist providers at Bobcares, we’ll study extra concerning the error.

Error: Unable to activate area or import MSSQL dump in Plesk: Signs

With one of many points listed under, we’re unable to activate/deactivate a site or import an MSSQL dump.

• Error: Unable to activate/deactivate area: Consumer or function 'db_user' doesn't exist on this database.
at (VADOConnection::execute line 90)
at Disable consumer db_user in MSSQL database database_name on host 203.0.113.2SQLEXPRESS.(domainmng::alter_mssql_users line 730)
at Flip off dbusers for area area.tld(domainmng::db_users_on_off line 486)
at (domainmng::db_users_on_off line 487)
at Flip off area area.tld (state=1)(domainmng::turnDomain line 120)Error: A few of the chosen subscriptions weren't activated.
Allow database consumer failed: mssqlmng failed: Consumer or function 'db_user' doesn't exist on this database. at (VADOConnection::execute line 78) at execute console command --access-user-enable(vconsoleapp::begin line 100) at execute "C:Program Information (x86)ParallelsPleskadminbinmssqlmng.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 identical downside will open up in Domains > instance.com > Databases > Consumer Administration > db consumer.

These are among the main signs of the error and we will now transfer on and study extra concerning the causes and the options for the error.

Error: can’t activate area or import MSSQL dump in Plesk: Causes and backbone

The database consumer is both not in map to the area’s database or isn’t current in MSSQL Server.

Answer for the error:

Comply with the steps given under to resolve the Plesk can’t activate area or import MSSQL error:

1. RDP is used to connect with the server.
2. In SQL Server Administration Studio, go to Safety > Logins > db consumer > Properties > Consumer Mapping and map the database to the consumer.

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

Conclusion

To sum up we’ve now seen the signs, causes and the decision for the error can’t activate area or import MSSQL dump in Plesk.

With the assist of our MSSQL assist providers at Bobcares we’ve now gone by way of the steps essential to take away the error simply.