1

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?

  • 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
0
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
1

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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