'connection failed'

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

From: DWN (DWN_at_discussions.microsoft.com)
Date: 03/02/05 

Date: Wed, 2 Mar 2005 12:55:06 -0800

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

  • Re: Slow booting xp home.
    ... Changing the boot order to boot first from your hard disk might save you a half second, but you won't be able to boot from a CD until you change it back - and the time spent to do that will erase any previous time saved. ... 2- Consider what software you really want to start with Windows and also how you've configured your applications at startup ... Installing and Registering Visual Studio Express Editions Smart Device ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: Slow booting xp home.
    ... Thirty seconds to boot Windows? ... I read somewhere that Microsoft suggest 30s boot up on xp home, I have seen videos on youtube of 8s boot up on xp, I'd be delighted with 30s and happy just to get below a minute. ... Installing and Registering Visual Studio Express Editions Smart Device ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: Remote connection failed
    ... If you are going over a remote connection or are not logging ... into the domain where SQL Server is then no, Windows ... authentication won't work. ...
    (microsoft.public.sqlserver.connect)
  • Re: Security Update for SQL Server 2005 Service Pack 2 (KB948109)
    ... If you're running Windows Live Mail, sign out then close the application. ... Understand that you can open a free support incident about your issues: ... When you call, clearly state that your problem is related to a Security Update and cite the update's KB number. ... SQL Server Database Services 2005 ENU SP2 ...
    (microsoft.public.windowsupdate)
  • Getting to the bottom of MSDE network connection problems ...
    ... but other than that it is MSDE 2000 with sp3a already applied. ... I've finally figured out the connection problems associated with this, ... and it seems the problems are due to Windows XP and not MSDE. ... the enterprise/standard versions of SQL server won't install ...
    (microsoft.public.sqlserver.msde)