Error. Microsoft SQL Server backup fails due to database permission issues

On this page

Error message

Backup failed for Server 'SQL_SERVER_INSTANCE_NAME'. Details: System.Data.SqlClient.SqlError: The server principal "NT AUTHORITY\SYSTEM" is not able to access the database "DATABASE_NAME" under the current security context.

Error description

The error may occur when backing up a Microsoft SQL Server database using OBRM.

Steps to resolve

  1. Open Microsoft SQL Server Management Studio.

  2. Connect to the SQL Server instance SQL_SERVER_INSTANCE_NAME, where backed up databases run;

  3. In Object Explorer, go to SecurityLogins.


  4. Find NT AUTHORITY\SYSTEM, right-click it, and click Properties.

    Login properties

  5. Go to User Mapping, select the required user database, select db_backupoperator, and then click OK.

    User mapping

  6. If several databases within the instance should be backed up, find them on the User Mapping page, select and add db_backupoperator role as at the previous step.

    User mapping

Restart the backup session, and check if it runs without problems for all selected databases.