Cannot generate SSPI Context Error

[mceboll]

Sometimes when we restart our Application server and it attempts to connect to the database, we get "Cannot generate SSPI Context."
Has anyone come across this type of error?

[skhanal]

Are you using linked server?

I have seen this happen on long running queries using a linked server.

If this is the case try to optimize the query or break into smaller pieces.

[mceboll]

Shailesh,

Thanks for you post.
I am not using a linked server. This error does not happen every time, just on an infrequent basis.

[skhanal]

It could be network time out issue too.

One work around is to use named pipe rather than tcp/ip to connect to the sql server which avoids all SSPI stuff.

This is a good article about SSPI, you will have to register to read it.

http://www.sqlservercentral.com/colu...intversion.asp