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?