Login to SQL Server 2k8 R2 SP1 via Active Directory Group 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)
It appears that because the security group was literally created moments before I added it as a Windows Auth Login that it hadn't synced yet with all the domain controllers.  It now appears to be functioning properly.

I apologize for the errant question.

Thanks,

Jeremie