1

After reading this article,

http://www.red-gate.com/supportcenter/content/knowledgebase/SQL_Backup/KB200710000173

I have some problems configuring point 2) and 3):

2) Create a SQL Server login that has the ability to backup (and restore) databases (y) by adding it to the SYSADMIN server role.

3) Add the domain account (x) to a security group on the SQL Server computer that has sufficient privileges to log on as a service, etc.

Where can I find detailed instructions/videos on how to accomplish them?

Thanks.

1 Answer 1

1

To answer your questions directly:

2) In order to add a login to the sysadmin fixed server role you can utilize ALTER SERVER ROLE ... ADD MEMBER (2012) or sp_addsrvrolemember (pre-2012). Here would be an example:

exec sp_addsrvrolemember 'yourLoginName', 'sysadmin';

3) Without having to reiterate what's found in the following documentation, take a look at this MSDN reference on the service permissions for each SQL Server service.

1
  • Thomas, I'm not a DB expert and I hardly follow the documentation provided. Isn't there anything more simple?
    – abenci
    Oct 22, 2013 at 7:50

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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