SQL Server Windows Auth Login not working

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 14:22 UTC
Read the original article Hit count: 334

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

Related posts about windows-server-2008

Related posts about sql-server