How can i add a group to the sysadmin fixed server role in SQL Server 2008 R2?
See my related question for details step-by-step screenshots detailing showing that you're not allowed to add groups to the sysadmin role.
Before SQL Server 2008 R2, members of the local
Administrators group were automatically added to the sysadmin fixed server role. Starting with SQL Server 2008 R2 that group is no longer added. The new recommended mechanism is to:
...create a separate Windows group containing the appropriate DBAs and grant that group the sysadmin role in the database.
How do i "grant a Windows group the sysadmin role"?
...users who are members of the BUILTIN\Administrators group are members of the sysadmin fixed server role automatically.
- BUILTIN\Administrators member of SYSADMIN fixed server role