Re: 'connection failed'

From: Mary Chipman [MSFT] (mchip_at_online.microsoft.com)
Date: 03/03/05 

Date: Thu, 03 Mar 2005 09:15:12 -0500

It might be an XP service pack problem -- see "FIX: You may receive a
"Cannot generate SSPI context" error message when you try to connect
to an instance of SQL Server 2000 SP3"
http://support.microsoft.com/default.aspx?scid=kb;en-us;883714.

--Mary

On Wed, 2 Mar 2005 12:55:06 -0800, DWN <DWN@discussions.microsoft.com>
wrote:

>I am using MS Access 2002 to link to some SQL Server 2000 tables, and run
>queries on them. After a few minutes, I get an error that reads:
>
>Connection failed:
>SQL State: 'S1000'
>SQL Server Error: 0
>[Microsoft][ODBC SQL Server Driver]Cannot Generate SSPI Context
>
>I can reboot, and it will start working again, and then it will fail again.
>I also have Enterprise Manager on my machine. If I go to EM after the error
>occurs, I get a similar error if I try to open a table.
>
>This happens from my desktop machine, using Windows XP. I can access the
>same tables from my laptop using Windows XP, and don't have this problem.
>I've been using this machine to access these tables in this manner for
>several months, and this problem just started occurring last week. The only
>thing strange that happened around that time was that I tried to run a
>Crystal Report against this database, and it crashed. But I'm not aware of
>anything that CR does that could mess up ODBC.
>
>I've deleted and recreated the ODBC data source on this computer, I have
>reinstalled MDAC (v. 2.81.1117.0) from the SQL Server installation disk, and
>I've reinstalled Enterprise Manager, but still have the problem.
>
>I've found articles about AUTOCOMMIT causing an SSPI problem, but I'm not
>explicity using any transaction commands. All I'm doing is opening tables
>via links from Access, and it'll work sometimes and then it won't.
>
>Any suggestions as to what else I can look at?
>
>thanks,
>DWN

Relevant Pages

  • connection failed
    ... I am using MS Access 2002 to link to some SQL Server 2000 tables, ... This happens from my desktop machine, using Windows XP. ... I've deleted and recreated the ODBC data source on this computer, ... I've reinstalled Enterprise Manager, ...
    (microsoft.public.data.odbc)
  • Cannot generate SSPI Context error
    ... I have a recurring problem with the "Cannot generate SSPI context" error. ... SQL Server is MSDE, client logging on with NT security, SQL Server is ... installed on the same physical server as the domain controller (only one ... Client is XP PRO, same problem with SP2 or without SP2 ...
    (microsoft.public.sqlserver.security)
  • Re: SQL 2000 Server odbc connection broken after 10-20 minutes
    ... common causes of the "Cannont Generate SSPI Context" error message: ... > or if the box is idle for awhile it cannot connect to the SQL server or it ... > Connection Failed ... > Cannont Generate SSPI Context ...
    (microsoft.public.sqlserver.connect)
  • RE: SSPI Context
    ... "Cannot generate SSPI context" error usually indicates a security issue. ... Does your SQL Server support Windows authentication? ...
    (microsoft.public.sqlserver.security)
  • Re: SSPI Context problem
    ... 269541 Missing Windows NT LM Security Support Provider registry key causes ... "Cannot Generate SSPI Context" error message when you connect to SQL Server ...
    (microsoft.public.sqlserver.programming)