Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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)
share|improve this question
    
Can you post what kind of error the user received? you might want to take a look at this link and correlate your error with it- blogs.msdn.com/b/sql_protocols/archive/2006/02/21/536201.aspx –  yogirk Sep 5 '12 at 17:41
1  
Did the user log out and log back in? Maybe it just needs a refreshing of their security token. –  squillman Sep 5 '12 at 17:45
    
So I deleted the individual users login and had him re-try and it let him login. I went to another user that is a member of that group and had him try to login for the first time and it worked. Moral of the story must be to wait a few moments for the domain controllers to sync up with each other if it's a brand new security group. –  Jeremie Grund Sep 5 '12 at 18:25

1 Answer 1

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

share|improve this answer
    
No problem. Appreciate your feedback. –  Edward Dortland Sep 6 '12 at 4:00
    
It's not an errant question - thank you to you for posting the answer, now anyone who is experiencing the same issue can at least know what caused yours. Please go ahead and mark your response as the answer, +1 ;-) –  Mr.Brownstone Sep 25 '12 at 21:45

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.