sql server connect: SQL 2000 Server odbc connection broken after 10-20 minutes -- sql server connect

SQL 2000 Server odbc connection broken after 10-20 minutes

Joseph Anthony
5/24/2005 8:04:01 AM

sql server connect:

We have an Access 2000 front end running on XP boxes connected to an SQL 2000
standard edition install on 2003 Server via ODBC. After about 10 or 20 mins
or if the box is idle for awhile it cannot connect to the SQL server or it
dies in the middle of working through the frontend. I get this:

Connection Failed
SQL Sate:S1000
SQL Server Error:0
Cannont Generate SSPI Context

We also have a Server 2000 box running Terminal Services, and they can
connect and stay connected with no problem to the database via the same front

Re: SQL 2000 Server odbc connection broken after 10-20 minutes

<msnews.microsoft.com>
7/13/2005 12:05:19 PM

If you have not read the following KB, you can check it to exclude the
common causes of the "Cannont Generate SSPI Context" error message:
http://support.microsoft.com/kb/811889/en-us

Another point you may consider is if there is any timeout setting on the
server side or on the XP box.

-billyy

"Joseph Anthony" <Joseph Anthony@discussions.microsoft.com> Ð´ÈëÓÊ¼þ
news:9735D3EE-DCFE-4878-8FB6-1246B505282E@microsoft.com...
[quoted text, click to view]