Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 SSPI handshake failed

Author  Topic 

kenchee
Starting Member

49 Posts

Posted - 2010-07-28 : 02:46:01
Hi,
A SQL 2005 SP2 CU7 instance on a 2003 cluster is getting "SSPI handshake failed with error code 0x80090304 while establishing a connection with integrated security; the connection has been closed. " and "Login failed for user ''. The user is not associated with a trusted SQL Server connection." error. This only occurs between the SQL Server and the Biztalk 2009 Server. Other application and servers are not getting this error at all even when this error between the sql server and biztalk. This does not occur frequently maybe once every 2 months and I can't replicate this error. Other times it's working perfectly, same user same password.
Searching around and the closest I found is due to multiple domain controllers with one of the DC being restarted or shutdown but I still cannot replicate the error.
I'm really stuck on this. Can anyone help or has similar issues?

Thanks

Ken
   

- Advertisement -