Re: ODBC Connection.

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Steve Thompson (stevethompson_at_nomail.please)
Date: 06/24/04

  • Next message: David Schleifer [MSFT]: "Re: .NET Performance - Native vs OLE DB"
    Date: Thu, 24 Jun 2004 09:29:30 -0400
    
    

    If you have not seen this troubleshooting page, you'll want to give this a
    read:

    How to troubleshoot the "Cannot generate SSPI context" error message
    http://support.microsoft.com/default.aspx?scid=kb;en-us;811889&Product=sql2k

    Steve
    "Nexus Quest" <anonymous@discussions.microsoft.com> wrote in message
    news:2066301c459c0$68371610$a601280a@phx.gbl...
    > 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.


  • Next message: David Schleifer [MSFT]: "Re: .NET Performance - Native vs OLE DB"

    Relevant Pages

    • Connection failed SQL State 01000 SQL error 52
      ... Connection failed ... SQL Server Error: 52 ... I have tried SQL Server authentication, ...
      (microsoft.public.project)
    • ODBC Connection.
      ... There is a problem with my ODBC connection. ... a connection time out occurs and the error ... SQL Server Error: 0 ...
      (microsoft.public.sqlserver.odbc)
    • Re: Connection failed: SQLState: S1T00
      ... SQL Server Error: 0 ... Windows Vista Premium. ... Apparently these computers are similar to a lot of others, ... If the connection succeeds the second time, ...
      (microsoft.public.vc.database)
    • Re: MSDE and ISA
      ... Both names appear in the dropdown list when creating the ODBC connection. ... Both instances use the same SA password and connection is made using SQL Authentication. ... SQL Server Error: 17 ... I think it may be related to ISA Server but cannot confirm at this stage ...
      (microsoft.public.sqlserver.msde)