I added an Active Directory group as a Windows Authentication Login to our SQL Server 2008 R2 database.
When a user who is a member of that group tries to connect to the server he is given a login failed error. If I add his specific username as a login, he is then able to connect.
Should I be able to add an Active Directory group to allow users in that group to connect? It would seem this would be preferred over individually managing specific users.
SELECT @@version; Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64)