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 confused 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 base seems to help. Also, strangely, 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

"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.