Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

2 Answers

up vote 0 down vote accepted
USE [master]
GO
CREATE LOGIN [DOMAIN\USER] FROM WINDOWS WITH DEFAULT_DATABASE=[master]
GO
EXEC master..sp_addsrvrolemember @loginame = N'DOMAIN\USER', @rolename = N'sysadmin'
GO
share|improve this answer
add comment

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
add comment

Your Answer

 
discard

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.