Unanswered: SSPI handshake failed with error code 0x80090308
I am using SQL Server 2005. I got the following error in event viewer. Tried to search info from web failed. Does anyone have idea? Thanks a lot
[EventMsg]=SSPI handshake failed with error code 0x80090308 while establishing a connection with integrated security; the connection has been closed. [CLIENT: 220.127.116.11]
I have seen this sort of error before, but I forget the exact details. This was due to a conflict in how SQL Server 2005 handled Kerberos tokens (at least in my case). The solution for me was to switch the default network protocol from tcp/ip to named pipes.