Granting access by Windows group membership
If you are running an SQL Server in either mode, but prefer to manage the SQL Server access by Windows group membership, you can do the following:
Create a Windows server or Active Directory group for users that require access to the SQL Server database(s).
Create a template account on the appropriate Windows server or Active Directory target system.
Ensure that the template user is a member of the designated group.
Grant the newly created group access to the server by following the procedure in Creating a template account for a Windows User login . In Step 6, replace the template ID with the group name.
When a new user is created from a template user, the new user becomes a member of the group and is granted access to the SQL Server.