"Login failed. The login is from an untrusted domain and cannot be used with Windows authentication."

Question

We have several computers accessing the sql server on a PC. When I try to connect it on one specific PC it gives this error:

"Login failed. The login is from an untrusted domain and cannot be used with Windows authentication."

..........but is working fine on other 10 PCs

 

---

Regards,
N_SQL
Unfortunate is he who cannot gain a few sincere friends during his life
...and more unfortunate is the one who has gained them and then lost them (through his deeds).

Answer 1

1. Please could you attach the complete error message you recive?

2. What version of SQL Server are we talking about.

 

In this post and the links it provides has a lot of reasons why you could end up and get the error message that you see, have a look here first.

http://blogs.msdn.com/b/sql_protocols/archive/2005/09/28/474698.aspx

- Raoul 

Answer 2

Have you checked this article?

http://blogs.msdn.com/b/sql_protocols/archive/2008/05/03/understanding-the-error-message-login-failed-for-user-the-user-is-not-associated-with-a-trusted-sql-server-connection.aspx

 

best regards,

---

Enrique Lima Solutions Architect | Apparatus, Inc. | http://geekswithblogs.com/enriquelima

Answer 3

We have solved an problem like this. We have programmed a service which sync data between Exchange and SQL. The solution was update Exchange 2007 to SP3 with the newest Rollup.

Answer 4

How are you logging on to the PC in question? Are you using a domain account?

---

Regards, Matt Bowler MCITP, My blog | SQL Services

Answer 5

CrashonAuditFail registry key set to 2 can cause this error as well, we set to 0 and issue went away immediately.

http://technet.microsoft.com/en-us/library/aa996838(v=exchg.80).aspx