Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am setting up a backup software to backup all the databases on my MS SQL Server 2008.

I want to configure a service account with administrator rights on the database. The service account have already been created in the AD, but has no rights at the moment.

How can I give database rights to my service account so that he will be able to launch backup tasks?

share|improve this question
Did you read the manual for RedGate SQL Backup Pro? – MDMarra May 4 '12 at 14:01
It has nothing to do with the backup software I am using. I just want to set up a service account for backing up SQL Server 2008. – Jonathan Rioux May 4 '12 at 14:03
up vote 0 down vote accepted
USE [master]
EXEC master..sp_addsrvrolemember @loginame = N'DOMAIN\USER', @rolename = N'sysadmin'
share|improve this answer

You said you were using RedGate for this. Though this is a SQL Server configuration issue, the RedGate documentation clearly walks you through how to do this.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.