SQL Server Windows Auth Login sees Domain as untrusted...
Posted
by Mr Shoubs
on Server Fault
See other posts from Server Fault
or by Mr Shoubs
Published on 2010-05-26T14:08:31Z
Indexed on
2010/05/26
15:03 UTC
Read the original article
Hit count: 512
windows-server-2008
|sql-server
|active-directory
|sql-server-2008
|domain-controller
I've had someone set up a domain controller on windows 2008 on one server, and sql server 2008 on another. The domain seems to be working fine, I'm logged on as a domain user on both servers, nothing seems to be a problem there.
However, when I try to add a domain user/group to SQL Server Security (e.g. clicking ok from the create login screen) it says it can't find it (even though I've used the search to find the correct account in the first place), when I try to logon (even though I haven't added it yet) it says something about the account being part of an untrusted domain instead of saying I don't have permission to log on.
Anyone have any ideas on what is set up incorrectly?
© Server Fault or respective owner