SQL Server 2008 Windows Auth Login Error: The login is from an untrusted domain
When attempting to connect to a SQL Server 2008 Instance using Management Studio, I get the following error:
Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. (Microsoft SQL Server, Error: 18452)
I can login using SQL Authentication without problem. I've been getting this error all of a sudden. I have Mixed Mode Authentication turned on.
Does anyone have any experience with this?
Additional Info: 64-bit version of SQL Enterprise Edition On Windows 2003 Server
Another reason this might happen (just happened to me) ... is the user's password expires. I didn't realize this until I tried to remote into the actual server and was prompted to change my password.
For me, this happened when I edited a blank drivers/etc/hosts file, and added an entry for a local website, but neglected to add 127.0.0.1 localhost
The issue was caused by a down Active Directory Server, which of course could not authenticate the Windows account. Thank you for your assistance.
For anyone else who runs into this, I had this in my hosts file:
127.0.0.1 localhost
127.0.0.1 customname
and I needed it to be this:
127.0.0.1 localhost
127.0.0.1 localhost customname
"The issue was caused by a down Active Directory Server, which of course could not authenticate the Windows account"
It is not "of course - because if AD is not available then Kerberos authentication falls back to NTLM (domain account credentials are cached locally, one can login with it even if AD/Kerberos is not available). I guess that you have possibly 2 simultaneous conditions for this failure to happen:
- SQL Server is not local (on another machine)
- The trust is configured "Kerberos only"
or other specific security network/server/AD/machine configurations