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

Verify Error

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)


Bnoles
0

Comments

3 comments

Sort by
  • petey2
    Are your running the verification task using SQL Server Agent or the Windows Task Scheduler?
    petey2
    0
  • PMA_IT
    I am running verification through the SQL Agent.
    PMA_IT
    0
  • 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.
    petey2
    0

Add comment

Please sign in to leave a comment.