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

Refers to:

  • Plesk 11.5 for Windows
  • Plesk 12.0 for Windows

Created:

2016-11-16 12:47:47 UTC

Modified:

2016-12-21 19:14:02 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.

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.