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?
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
No related posts.