How to give an active directory group access to SQL server? (AD group SQL server)

Verify the members in the active directory group

First make sure that the AD group doesn't have any member that you don't want to give access to your SQL server by running this command on the command prompt.

NET GROUP myGroupName /domain

This above command will give you all the members in the active directory group myGroupName .(only replace myGroupName , rest of the command remains as is)


Give the AD Group login permission to SQL server

CREATE LOGIN [myGroupName] FROM WINDOWS WITH DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english]