Backup Permissions
sigos
Posts: 1 New member
I am having an issue where I get a permission error when backing up from the schedule job full/differential jobs. When I request the backup job manually I get success.
I tried entering the regedit for skipchecks =1 but it does not seem to work.
Any thoughts?
SQL Backup log file 9.1.4.177
-SQL "BACKUP DATABASES [model,msdb,appmonamericas,MC_Internal_3_3,pocdb03,ReportServer$AMPSQLINTL,ReportServer$AMPSQLINTLTempDB] TO DISK = 'I:\Backup\<database>\<AUTO>.sqb' WITH ERASEFILES_ATSTART = 15, CHECKSUM, DISKRETRYINTERVAL = 30, DISKRETRYCOUNT =
10, COMPRESSION = 2, THREADCOUNT = 3, DIFFERENTIAL "
ERRORS AND WARNINGS
10/27/2017 1:38:45 PM: Backing up model (differential database) on AMPSQLINTL instance to:
10/27/2017 1:38:45 PM: I:\Backup\model\DIFF_AMPSQLINTL_model_20171027_133845.sqb
10/27/2017 1:38:45 PM: Error 880: BACKUP DATABASE permission denied in database: (model)
10/27/2017 1:38:45 PM: SQL error 15157: Setuser failed because of one of the following reasons: the database principal 'QA\AMPSQLINTERNAL$' 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.
10/27/2017 1:38:45 PM: Backing up msdb (differential database) on AMPSQLINTL instance to:
10/27/2017 1:38:45 PM: I:\Backup\msdb\DIFF_AMPSQLINTL_msdb_20171027_133845.sqb
10/27/2017 1:38:46 PM: Error 880: BACKUP DATABASE permission denied in database: (msdb)
10/27/2017 1:38:46 PM: SQL error 15157: Setuser failed because of one of the following reasons: the database principal 'QA\AMPSQLINTERNAL$' 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.
10/27/2017 1:38:46 PM: Backing up appmonamericas (differential database) on AMPSQLINTL instance to:
10/27/2017 1:38:46 PM: I:\Backup\appmonamericas\DIFF_AMPSQLINTL_appmonamericas_20171027_133846.sqb
10/27/2017 1:38:46 PM: Error 880: BACKUP DATABASE permission denied in database: (appmonamericas)
10/27/2017 1:38:46 PM: SQL error 15157: Setuser failed because of one of the following reasons: the database principal 'QA\AMPSQLINTERNAL$' 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.
10/27/2017 1:38:46 PM: Backing up MC_Internal_3_3 (differential database) on AMPSQLINTL instance to:
10/27/2017 1:38:46 PM: I:\Backup\MC_Internal_3_3\DIFF_AMPSQLINTL_MC_Internal_3_3_20171027_133846.sqb
10/27/2017 1:38:47 PM: Error 880: BACKUP DATABASE permission denied in database: (MC_Internal_3_3)
10/27/2017 1:38:47 PM: SQL error 15157: Setuser failed because of one of the following reasons: the database principal 'QA\AMPSQLINTERNAL$' 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.
10/27/2017 1:38:47 PM: Backing up pocdb03 (differential database) on AMPSQLINTL instance to:
10/27/2017 1:38:47 PM: I:\Backup\pocdb03\DIFF_AMPSQLINTL_pocdb03_20171027_133847.sqb
10/27/2017 1:38:47 PM: Error 880: BACKUP DATABASE permission denied in database: (pocdb03)
10/27/2017 1:38:47 PM: SQL error 15157: Setuser failed because of one of the following reasons: the database principal 'QA\AMPSQLINTERNAL$' 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.
10/27/2017 1:38:47 PM: Backing up ReportServer$AMPSQLINTL (differential database) on AMPSQLINTL instance to:
10/27/2017 1:38:47 PM: I:\Backup\ReportServer$AMPSQLINTL\DIFF_AMPSQLINTL_ReportServer$AMPSQLINTL_20171027_133847.sqb
10/27/2017 1:38:48 PM: Error 880: BACKUP DATABASE permission denied in database: (ReportServer$AMPSQLINTL)
10/27/2017 1:38:48 PM: SQL error 15157: Setuser failed because of one of the following reasons: the database principal 'QA\AMPSQLINTERNAL$' 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.
10/27/2017 1:38:48 PM: Backing up ReportServer$AMPSQLINTLTempDB (differential database) on AMPSQLINTL instance to:
10/27/2017 1:38:48 PM: I:\Backup\ReportServer$AMPSQLINTLTempDB\DIFF_AMPSQLINTL_ReportServer$AMPSQLINTLTempDB_20171027_133848.sqb
10/27/2017 1:38:49 PM: Error 880: BACKUP DATABASE permission denied in database: (ReportServer$AMPSQLINTLTempDB)
10/27/2017 1:38:49 PM: SQL error 15157: Setuser failed because of one of the following reasons: the database principal 'QA\AMPSQLINTERNAL$' 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 tried entering the regedit for skipchecks =1 but it does not seem to work.
Any thoughts?
SQL Backup log file 9.1.4.177
-SQL "BACKUP DATABASES [model,msdb,appmonamericas,MC_Internal_3_3,pocdb03,ReportServer$AMPSQLINTL,ReportServer$AMPSQLINTLTempDB] TO DISK = 'I:\Backup\<database>\<AUTO>.sqb' WITH ERASEFILES_ATSTART = 15, CHECKSUM, DISKRETRYINTERVAL = 30, DISKRETRYCOUNT =
10, COMPRESSION = 2, THREADCOUNT = 3, DIFFERENTIAL "
ERRORS AND WARNINGS
10/27/2017 1:38:45 PM: Backing up model (differential database) on AMPSQLINTL instance to:
10/27/2017 1:38:45 PM: I:\Backup\model\DIFF_AMPSQLINTL_model_20171027_133845.sqb
10/27/2017 1:38:45 PM: Error 880: BACKUP DATABASE permission denied in database: (model)
10/27/2017 1:38:45 PM: SQL error 15157: Setuser failed because of one of the following reasons: the database principal 'QA\AMPSQLINTERNAL$' 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.
10/27/2017 1:38:45 PM: Backing up msdb (differential database) on AMPSQLINTL instance to:
10/27/2017 1:38:45 PM: I:\Backup\msdb\DIFF_AMPSQLINTL_msdb_20171027_133845.sqb
10/27/2017 1:38:46 PM: Error 880: BACKUP DATABASE permission denied in database: (msdb)
10/27/2017 1:38:46 PM: SQL error 15157: Setuser failed because of one of the following reasons: the database principal 'QA\AMPSQLINTERNAL$' 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.
10/27/2017 1:38:46 PM: Backing up appmonamericas (differential database) on AMPSQLINTL instance to:
10/27/2017 1:38:46 PM: I:\Backup\appmonamericas\DIFF_AMPSQLINTL_appmonamericas_20171027_133846.sqb
10/27/2017 1:38:46 PM: Error 880: BACKUP DATABASE permission denied in database: (appmonamericas)
10/27/2017 1:38:46 PM: SQL error 15157: Setuser failed because of one of the following reasons: the database principal 'QA\AMPSQLINTERNAL$' 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.
10/27/2017 1:38:46 PM: Backing up MC_Internal_3_3 (differential database) on AMPSQLINTL instance to:
10/27/2017 1:38:46 PM: I:\Backup\MC_Internal_3_3\DIFF_AMPSQLINTL_MC_Internal_3_3_20171027_133846.sqb
10/27/2017 1:38:47 PM: Error 880: BACKUP DATABASE permission denied in database: (MC_Internal_3_3)
10/27/2017 1:38:47 PM: SQL error 15157: Setuser failed because of one of the following reasons: the database principal 'QA\AMPSQLINTERNAL$' 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.
10/27/2017 1:38:47 PM: Backing up pocdb03 (differential database) on AMPSQLINTL instance to:
10/27/2017 1:38:47 PM: I:\Backup\pocdb03\DIFF_AMPSQLINTL_pocdb03_20171027_133847.sqb
10/27/2017 1:38:47 PM: Error 880: BACKUP DATABASE permission denied in database: (pocdb03)
10/27/2017 1:38:47 PM: SQL error 15157: Setuser failed because of one of the following reasons: the database principal 'QA\AMPSQLINTERNAL$' 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.
10/27/2017 1:38:47 PM: Backing up ReportServer$AMPSQLINTL (differential database) on AMPSQLINTL instance to:
10/27/2017 1:38:47 PM: I:\Backup\ReportServer$AMPSQLINTL\DIFF_AMPSQLINTL_ReportServer$AMPSQLINTL_20171027_133847.sqb
10/27/2017 1:38:48 PM: Error 880: BACKUP DATABASE permission denied in database: (ReportServer$AMPSQLINTL)
10/27/2017 1:38:48 PM: SQL error 15157: Setuser failed because of one of the following reasons: the database principal 'QA\AMPSQLINTERNAL$' 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.
10/27/2017 1:38:48 PM: Backing up ReportServer$AMPSQLINTLTempDB (differential database) on AMPSQLINTL instance to:
10/27/2017 1:38:48 PM: I:\Backup\ReportServer$AMPSQLINTLTempDB\DIFF_AMPSQLINTL_ReportServer$AMPSQLINTLTempDB_20171027_133848.sqb
10/27/2017 1:38:49 PM: Error 880: BACKUP DATABASE permission denied in database: (ReportServer$AMPSQLINTLTempDB)
10/27/2017 1:38:49 PM: SQL error 15157: Setuser failed because of one of the following reasons: the database principal 'QA\AMPSQLINTERNAL$' 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.
Tagged:
Answers
Thank you for your forum post.
The SkipChecks registry key needs to be REG_DWord type. From your screen shot I believe the type has been configured as REG_QWORD.
Many Thanks
Eddie
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com