Backup creation failed. Cannot open database "my_db_name" requested by the login.

Created:

2016-11-16 12:47:47 UTC

Modified:

2017-08-16 18:29:20 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Backup creation failed. Cannot open database "my_db_name" requested by the login.

Applicable to:

  • Plesk 11.x for Windows
  • Plesk 12.0 for Windows

Symptoms

Backup creation failed on Plesk 11.5 for Windows with error:

Cannot open database "my_db_name" requested by the login. The login failed.
Login failed for user 'NT AUTHORITY\\SYSTEM'.

Cause

MSSQL user does not have proper permissions for database "my_db_name".

Resolution

Go to SQL Server -> Security -> Logins and right click on NT AUTHORITY\NETWORK SERVICE and select Properties .

  1. In newly opened screen of Login Properties , go to the "User Mapping" tab
  2. Select the "my_db_name" database
  3. Then set the role as db_owner and Click OK .
Have more questions? Submit a request
Please sign in to leave a comment.