Does any one have any experience writing a script that would grant an AD domain group sysadmin rights to a SQL Server?
Below are two scripts that use SMO to accomplish this task.
If the login already exists, just use:
To add a domain group to SQL Server, then grant it sysadmin access, use:
Powered by IDERA