| Author |
Message |
kthiongo
Joined: 30 Apr 2012 Posts: 2
|
Posted: Wed May 09, 2012 9:26 pm Post subject: Error 880 |
|
|
Backup Jobs keep failing with the error message
5/9/2012 4:21:34 PM: Error 880: BACKUP DATABASE permission denied in database: (db_name)
5/9/2012 4:21:34 PM: SQL error 15157: Setuser failed because of one of the following reasons: the database principal 'DOMAIN\USER' 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.
The registry fix listed on the site doesn't work.  |
|
| Back to top |
|
 |
chriskelly
Joined: 19 Apr 2010 Posts: 252 Location: Cambridge, UK
|
Posted: Thu May 10, 2012 10:31 pm Post subject: |
|
|
When you say that the registry fix doesn't work, could you give some clarification? Were you unable to locate the registry key, or create it, or something else? _________________ Chris Kelly
Technical Support Engineer |
|
| Back to top |
|
 |
kthiongo
Joined: 30 Apr 2012 Posts: 2
|
Posted: Fri May 11, 2012 2:55 pm Post subject: |
|
|
We have a 64bit system so i added the SkipChecks registry key to
HKEY_LOCAL MACHINE\Software\Wow6432\Red Gate\SQL Backup\BackupSettingsGlobal\(LOCAL)
that didn't fix it
i tried the fix on the
HKEY_LOCAL MACHINE\Software\Red Gate\SQL Backup\BackupSettingsGlobal\(LOCAL) folder and it worked |
|
| Back to top |
|
 |
|
|
All times are GMT + 1 Hour
|
| Page 1 of 1 |
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group