patternMinor
Login to SQL Server 2k8 R2 SP1 via Active Directory Group
Viewed 0 times
directoryactivegroupsql2k8loginviasp1server
Problem
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.
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)Solution
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
I apologize for the errant question.
Thanks,
Jeremie
Context
StackExchange Database Administrators Q#23734, answer score: 2
Revisions (0)
No revisions yet.