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
which states that the service account has to be sysadmin.

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

Best Answer


  • noob2016noob2016 Posts: 22 Bronze 3
    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
Sign In or Register to comment.