Question :
I have a AD group that needs to be added to multiple SQL instances, I am wondering is there a quicker way of adding this group at once rather than having to login to each server and creating a login in SQL?
Thanks!
Answer :
Download the awesome Powershell scripts from dbatools and use New-DbaLogin to add the new login.
Example:
New-DbaLogin -SqlInstance sql1 -Login domainuser
You can set up a Central Management Server. Once you’ve done that, you can apply the same script (CREATE LOGIN [Your_AD_Group] FROM WINDOWS WITH ...
) to multiple SQL instances at the same time.