Tuesday, February 14, 2012

Cannot generate SSPI Context

I'm running Server 2003 (with Active Directory) and SQL Server 2000. I see
SQL for a while from a client computer but then seem to lose my connection.
At this point, if I try to connect I'll get the "Cannot generate SSPI
Context" error message. It seems like I'm fine as long as I keep Query
Analyzer open but as soon as I close it and try to re-open it I get the
error. This doesn't seem to happen from another computer which isn't even a
member of the same domain.
Most replies to similar posts suggest
http://support.microsoft.com/defaul...kb;en-us;811889 as a source
for a possible fix. Either my problem is different or I'm too dense get the
clues found in the article. I'm desperate for help. Can somebody who has
been helped by the referenced article tell me what changes they made that
solved the problem?If you are using WINS make sure that your WINS computers are configured
correctly. Also, verify that the client is pointing to a valid DNS server.
In some cases, a client can be configured to use an external DNS server
which can cause this problem. Use ipconfig /all to look at the configured
DNS servers.
Rand
This posting is provided "as is" with no warranties and confers no rights.

No comments:

Post a Comment