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

    • Summary:Steps to resolve the issue when backing up a Microsoft SQL Server database using Online Backup and Recovery Manager.
    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 Security › Logins.

      Logins

    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.