Red Gate forums :: View topic - SQL Backup 4.0 ONLY - Check service user account
Return to www.red-gate.com RSS Feed Available

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

SQL Backup 4.0 ONLY - Check service user account

Search in SQL Backup Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
HJoyce



Joined: 10 Oct 2005
Posts: 183

PostPosted: Thu Jan 19, 2006 11:20 am    Post subject: SQL Backup 4.0 ONLY - Check service user account Reply with quote

If you encounter errors with regards to access rights, you should first check if the SQL Backup Agent service startup user has been granted the necessary rights.

By default, the SQL Backup Agent connects to the SQL Server instance using Windows authentication. The 'SQL Backup Agent' service is started using 'Local System' account. This will cause problems for example if the Builtin\Administrators group has been removed.

You can choose to have the SQL Backup Agent connect using SQL authentication, by using the sqbsetlogin extended stored procedure to provide the login name and password.

You need to add this extended stored procedure first before using it:

sp_addextendedproc sqbsetlogin, 'xp_sqlbackup.dll'

Use the sqbsetlogin extended stored procedure to set the SQL login and password e.g.

sqbsetlogin 'sa', 'sqbrocks'

To revert to Windows authentication, provide blank values for the parameters e.g.

sqbsetlogin '', ''


It is recommended that you remove this extended stored procedure when you have completed your modifications.

sp_dropextendedproc sqbsetlogin

The service application's service startup user needs to be an account that has the SQL Server sysadmin fixed server role, in order to process backups and restores successfully. If you are also working with network files e.g. copying to network shares, this user needs to have access to those network shares too.
Back to top
View user's profile Send private message Send e-mail
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