Error 880 in running a scheduled backup job
eugenecy
Posts: 1
in SQL Backup
I am having the Error 880 in running a scheduled backup job:
03/08/2017 08:27:57: Error 880: BACKUP DATABASE permission denied in database: (MyDB)
03/08/2017 08:27:57: SQL error 15157: Setuser failed because of one of the following reasons: the database principal 'MYDOMAIN\MYSERVER$' 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.
I found in the forum about the SkipChecks registry fix but I am still getting the same error. the job owner is sysadmin but the runas dropdown box is empty in the tsql step.
03/08/2017 08:27:57: Error 880: BACKUP DATABASE permission denied in database: (MyDB)
03/08/2017 08:27:57: SQL error 15157: Setuser failed because of one of the following reasons: the database principal 'MYDOMAIN\MYSERVER$' 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.
I found in the forum about the SkipChecks registry fix but I am still getting the same error. the job owner is sysadmin but the runas dropdown box is empty in the tsql step.
