Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tbrothers
Yak Posting Veteran
83 Posts |
 Posted - 2012-07-31 : 10:03:17
|
| Hello,SQL 2008 R2Active Directory 2008I've setup a couple of AD groups (Global Security) and I have added them as SQL Logins and mapped them to specific databases with dbo permission. I added a user to the AD groups but he cannot connect to the database via SSMS or ODBC.Any ideas?Regards,Terry |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2012-07-31 : 12:32:29
|
What error message is the user getting? What do you see in the event logs? |
 |
|
|
tbrothers
Yak Posting Veteran
83 Posts |
Posted - 2012-07-31 : 14:36:38
|
| Yep - The error message would help ... duh.I did figure it out. I can't say what caused the problem but it is fixed. I deleted the SQL Login (domain\dbo_group) and added it back exactly like it was and now it works. I did the same for both groups.The error wasLogin failed for user 'domain\user'. Reason: Token-based server access validation failed with an infrastructure error. Check for previous errors. [CLIENT: ip address]Thanks all!!Terry |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2012-07-31 : 16:20:21
|
| That sounds like a failed connection -- a network error. Couldn't connect to the domain controller. |
|
|
|
|
|
|
Active Directory Groups