I am trying to understand if I can do the following. Let's say there are 10 user in my Active Directory. I created a Group called - "Manager" and added 5 members in that group. Then I added that Windows Group to the SQL Server and gave access to databases. So everytime I try to login or create a connection using one of the user credentials that is in that group - I get an error that user doesn't exist or don't have access. What am I doing wrong?