ODBC Connection.

From: Nexus Quest (anonymous_at_discussions.microsoft.com)
Date: 06/24/04 

Date: Thu, 24 Jun 2004 00:53:59 -0700

There is a problem with my ODBC connection. Usually after
about 30 mins, a connection time out occurs and the error
message displayed is as foolows:

Connection failed:
SQLState: 'S1000'
SQL Server Error: 0
SQL Server Error: 0
[Microsoft][ODBC SQL Server Driver]Cannot generate SSPI
context

I'm currently using Microsoft Windows Server 2003 for
Small Business Servers as my back-end server while my
client is using Microsoft Office Access 2003.

This problem does not occur in certain computers,
regardless of the authenticated users.

Normally what i would do when this problem occurs, will
be to log off and re login to windows. However this is
quite time consuming and i was wondering if there is any
way that this problem can be solved.

Relevant Pages

  • Re: Upsizing wizard access Sql Server express
    ... Sylvain Lafontaine, ing. ... Troubleshooting connection problem: ... database into sql server express 2005 by using the upsizing wizardi go ... SQL Server Error: 2 ...
    (microsoft.public.access.adp.sqlserver)
  • Connection failed SQL State 01000 SQL error 52
    ... Connection failed ... SQL Server Error: 52 ... I have tried SQL Server authentication, ...
    (microsoft.public.project)
  • Re: Upsizing wizard access Sql Server express
    ... Troubleshooting connection problem: ... database into sql server express 2005 by using the upsizing wizardi go ... SQL Server Error: 2 ... I downloaded SSMA but my work environment does not allow for the ...
    (microsoft.public.access.adp.sqlserver)
  • ODBC Connect Prob in 2005
    ... Connection Failed: ... SQLState: '08001' ... SQL Server Error: 1326 ... SQL Server Error: 0 ...
    (microsoft.public.sqlserver.odbc)
  • 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)