wingnut144
13 years agoLevel 4
Error when testing backup job / MSSQL 2005
I am trying to create a backup job several MSSQL databases I need to back up as well. When I go through and create the job, and test the resource credentials, I don't get an error for the databases.
But when I run a test run of the job, I'm getting the error below. I have checked on the MSSQL database that the same default user that BE2010 uses is the database settings. I have tried to add that user into the server roles in the 'sysadmin' group.
And I have tried adding that same user into: security>logins and set set it up with backup operator permissions for the database in question.
Each time, I'm getting:
Check status : Error: e0009b84, The job failed with the following error: The logon account that was provided does not have the appropriate privileges to back up the SQL database . Either assign the appropriate privileges to this logon account, or use another logon account.