How can we help you today? How can we help you today?

Service Account security

Our company's security team requires that the Service Account used to start SQL Server and SQL Server Agent services not a SYSADMIN on the server.
With SQL Backup, I get an error when the backup job runs with error code 880. I found https://documentation.red-gate.com/sbu7/errors-and-warnings/sql-backup-errors-500-5292
which states that the service account has to be sysadmin.

Anyone have a workaround / solution besides changing registry?
Thank you
noob2016
0

Comments

2 comments

Sort by
  • petey2
    Try assigning the 'db_owner' or 'db_backupoperator' role to the SQL Server Agent service startup account for that database and see if the backup works.
    petey2
    0
  • noob2016
    Great suggestion. Initial test shows DB_BACKUPOPERATOR fixed the issue.
    I would have thought it needed similar role to MSDB considering it's a job, but surprisingly, not.

    Will update further if it fails when the job runs by itself.
    Thank you Petey2
    noob2016
    0

Add comment

Please sign in to leave a comment.