Tuesday, February 14, 2012

cannot generate sspi context

SQL server 2000 SP4 has been running for several years. We added a new
Client PC, our first with the XP operating system. Microsoft Access 2000 is
the front end, and all tables and views on the server are connected thru an
ODBC connection. Everyone else in the office works fine, but the new XP
machine, after several minutes of inactivity, seems to lose its connection.
The Access app reports an ODBC error, and we see the "Cannot generate SSPI
context" message. We actually have to reboot the client PC, since even
testing the ODBC connection in the Control Panel fails.
Any ideas?
Try the following article:
How to troubleshoot the "Cannot generate SSPI context" error
message
http://support.microsoft.com/?id=811889
-Sue
On Tue, 23 Aug 2005 12:03:03 -0700, "menacher"
<menacher@.discussions.microsoft.com> wrote:

>SQL server 2000 SP4 has been running for several years. We added a new
>Client PC, our first with the XP operating system. Microsoft Access 2000 is
>the front end, and all tables and views on the server are connected thru an
>ODBC connection. Everyone else in the office works fine, but the new XP
>machine, after several minutes of inactivity, seems to lose its connection.
>The Access app reports an ODBC error, and we see the "Cannot generate SSPI
>context" message. We actually have to reboot the client PC, since even
>testing the ODBC connection in the Control Panel fails.
>Any ideas?

No comments:

Post a Comment