Microsoft SQL Server users from OU/SG

Question

MSSQL has its own user authentication apart from the operating system or Active Directory user authentication but can I apply database permissions to organisational units or security groups or somehow tie those to MSSQL?

Answer 1

1. At the SQL Server instance level, create a SQL Server login for the AD group.
2. Add a user to the database.
3. (Optional, but good practice). Create a database role.
4. Link the role to user.
5. Add permissions to the role.