Tuesday, February 14, 2012

Cannot generate SSPI context

Hi All,
I am experiencing problems with a remote user (w2k pro,sql 7) attempting
to connect and replicate with a Sql Server 7 on NT server.
They are receiving 'Cannot generate SSPI context' messages when trying to
use a vb app over a vpn. This problem cleared (perhaps due to a server
reboot) but then they experienced replication failure:
'The process could not connect to Publisher 'xyz''.'Cannot generate SSPI
context'.
There has been no re-configuration of the server and I am assured none at
the client end. However I experienced the problem once recently and it has
not occurred since. No other users are experiencing the same problem.I am co
nfused as to why it should start now.
Any help appreciated,
DaveD.I'm having a similar problem and am desperate for help. Please let me know
if you find a solution. I'm running Server 2003 (with Active Directory) and
SQL Server 2000. Nothing that I've read in any of the existing knowlege ba
se seems to help. Also, st
rangely, a friend at a completely unrelated company started getting the same
problem on the same day. We are wondering if it was a result of a virus or
Windows Update.
In my case, I see SQL for a while from a client computer but then seem to lo
se my connection. I'm fine as long as I keep Query Analyzer open but as soo
n as I close it and try to re-open it I get the error.|||"Cannot Generate SSPI Context" indicates a problem with Kerberos or with
the configuration of Kerberos. If it is a consistent problem it may be a
bad SPN (often the SPN incorrectly belongs to the computer instead of to
the account used to start the SQL Server service). If it is an intermittent
problem it may have to do with communications to the PDC or KDC.
811889 HOW TO: Troubleshoot the "Cannot Generate SSPI Context" Error Message
http://support.microsoft.com/?id=811889
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.

No comments:

Post a Comment