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
This problem may be due to the incorrect server authentication method used by your database server. If this case, you can try to right-click your server in SQL--select properties, and check the server authentication as “SQL Server and Windows Authentication Mode” in the security page.
In SQL Server Management Studio Object Explorer, right-click the server, and then click Properties. On the Security page, under Server authentication, select the new server authentication mode, and then click OK.
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
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With