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?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
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.