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

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@xxxxxxxxxxxxxxxxxxxxxxxxx> дÈëÓʼþ
news:9735D3EE-DCFE-4878-8FB6-1246B505282E@xxxxxxxxxxxxxxxx
> 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
> end. Could someone please help me resolve this issue?


.

Relevant Pages

  • Re: Connection string problem with sql 2000
    ... connection to SQL server when its not even opened on the machine. ... when trying to connect with my standard connection stsrings using SSPI, ... I get an error back saying can not create SSPI context. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Error "SQL Server does not allow remote connections"
    ... The application could not connect to the sql server db. ... network is blocking the connection. ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 ... integratedSecurity, SqlConnection owningObject) +737554 ...
    (microsoft.public.dotnet.framework.aspnet)
  • ADO.net Orcas Samples Install Problem
    ... An error has occurred while establishing a connection to the server. ... When connecting to SQL Server 2005, this failure may be caused by the ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, ... or am I better off with a full SQL Server install. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: OpenDataSource SQL Server xpress problem
    ... I tried your suggestions with some success. ... I tried setting up the .odc file through the Word Mail Merge wizard as ... If I work through the dialog to connect and then click the 'Test Connection' ... but I suspect it's because until recently most SQL Server ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Connection from remote computer to network SQL Server
    ... There is no firewall on the W2K machine acting as the SQL server. ... I tried making the SQL machine a "trusted" on the router. ... connection works. ... To find the IP address of your computer inside the network, ...
    (microsoft.public.access.adp.sqlserver)