Red Gate forums :: View topic - Error 880: BACKUP DATABASE permission denied in database
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 7
SQL Backup 7 forum

Error 880: BACKUP DATABASE permission denied in database

Search in SQL Backup 7 forum
Post new topic   Reply to topic
Jump to:  
Author Message
KristoferW



Joined: 29 Dec 2010
Posts: 8
Location: Hannover / Germany

PostPosted: Tue Mar 18, 2014 1:43 pm    Post subject: Error 880: BACKUP DATABASE permission denied in database Reply with quote

Hello,

i'm on a new System (Windows Server 2012 R2 / SQL Server 2012 Enterprise) with a fresh install of SQL Backup 7.6
The SQL Backup Service runs under a Domain User with appropriate permissions.

But the scheduled Backup Jobs failed with Error 880.
Code:

17.03.2014 20:10:00: Error 880: BACKUP DATABASE permission denied in database:  (master)
17.03.2014 20:10:00: SQL error 15157: Fehler bei 'Setuser' aufgrund einer der folgenden Ursachen: Der Datenbankprinzipal 'DOMAIN\XXXX-SQL-01$' ist nicht vorhanden, der entsprechende Serverprinzipal hat keinen Serverzugriff, für diese Art von
 Datenbankprinzipal ist kein Identitätswechsel möglich, oder Sie haben nicht die erforderliche Berechtigung.


I added SkipChecks = 1 to the Registry.
Now the Backup runs without errors, but the Jobs run under the Server-User "DOMAIN\XXXX-SQL-01$" and not with the Useraccount specified for the SQL Backup Service.

How can i get the Backup Service to run under the correct Domain User Account?

Thanks
Kristofer
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 924
Location: Red Gate Software

PostPosted: Wed Mar 19, 2014 4:49 pm    Post subject: Reply with quote

Thank you for your support request.

The SkipChecks registry key simply prevents SQL Backup from performing the User Rights check.

Scheduled jobs, use the SQL Agent to trigger the command to the SQL Backup Extended Stored procedure so the backup or restore runs.

I suspect the Job owner or the SQL Agent service account is being picked up as the account running the job. Is this incorrect user being displayed in SSMS or SQL Backup GUI or both?

Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
KristoferW



Joined: 29 Dec 2010
Posts: 8
Location: Hannover / Germany

PostPosted: Fri Mar 21, 2014 11:23 am    Post subject: Reply with quote

Hi Eddi,

thanks for your reply.

The incorrect user is being displayed in the GUI and in the error message.

Now things go strange... I changed nothing, but suddenly the scheduled jobs are running under the SQLAgent account.
Nonetheless the jobs schould run under the correct domain user.

- The jobs are owned by "sa".
- The SQLBackup Service is running under the domain account DOMAIN\SQL-Mgnt-Service

Please take a look at the screenshots http://1drv.ms/1nJ7E02

Thank you!
Kristofer
Back to top
View user's profile Send private message
eddie davis



Joined: 14 Jun 2006
Posts: 924
Location: Red Gate Software

PostPosted: Tue Mar 25, 2014 5:07 pm    Post subject: Reply with quote

Thank you for your reply.

The user name you see displayed in the User name field in the activity history is the task owner.

For scheduled backup and restore tasks, this is either the owner of the scheduled job or the account given to the SQL Agent.

For backup and restore tasks created through the GUI using either the backup or restore wizard, will show as the logged in user of the GUI.

Many Thanks
Eddie
_________________
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Back to top
View user's profile Send private message Send e-mail
KristoferW



Joined: 29 Dec 2010
Posts: 8
Location: Hannover / Germany

PostPosted: Wed Apr 02, 2014 1:11 pm    Post subject: Reply with quote

Hi Eddie,

thanks for the clarification.


kind regards
Kristofer
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic 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