Verify Error

PMA_IT

Getting this error on Verify in SQL Backup 10.  I've tried every authentication I have and still get the same error.  This error only occurs when it is run from the scheduler.  If I run manually everything works.

SQL error 15157: Setuser failed because of one of the following reasons: the database principal 'PMA\IRDB$' does not exist, its corresponding server principal does not have server access, this type of database principal cannot be impersonated, or you do not have permission.

Error 880: BACKUP DATABASE permission denied in database:  (ImageRight)

petey2

Are your running the verification task using SQL Server Agent or the Windows Task Scheduler?

PMA_IT

I am running verification through the SQL Agent.  

petey2

Try changing the SQL Server Agent service startup account to an account that is a member of the SQL Server sysadmin fixed server role.