Re: 'connection failed'

Tech-Archive recommends: Speed Up your PC by fixing your registry

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

  • Next message: Cristiano _at_ BH: "ODBC in DevC++" 
    Date: Thu, 3 Mar 2005 09:31:04 -0800

    It doesn't appear to be a service pack problem. My XP machine already has
    SP2. The server is Windows 2000 SP 4.

    I can initially connect to the server, but the connection is dropped after a
    few minutes. Also, the error code is different from the one in the article.

    thanks,
    DWN

    "Mary Chipman [MSFT]" wrote:

    > 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
    >
    >

  • Next message: Cristiano _at_ BH: "ODBC in DevC++"

    Relevant Pages

    • SecurityFocus Microsoft Newsletter #154
      ... MICROSOFT VULNERABILITY SUMMARY ... ISS RealSecure Server Sensor SSL Denial Of Service Vulnerabi... ... Roger Wilco Remote Server Side Buffer Overrun Vulnerability ... available for Microsoft Windows operating systems. ...
      (Focus-Microsoft)
    • SecurityFocus Microsoft Newsletter #49
      ... Subject: SecurityFocus Microsoft Newsletter #49 ... Microsoft Windows NNTP Denial of Service Vulnerability ... Microsoft IIS SSI Buffer Overrun Privelege Elevation Vulnerability ... Microsoft ISA Server H.323 Memory Leak Denial of Service... ...
      (Focus-Microsoft)
    • ~~~~~~~~~~~~~~~ CANNOT FIND ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
      ... cannot find server or dns error ... windows cannot find null ... windows cannot find the network path ... cannot find internet explorer on computer ...
      (comp.protocols.snmp)
    • Questions Relating to Administering Windows 2000 Server
      ... installed the network client on the target computer. ... Sarah has been attempting to install Windows 2000 ... Server for two days. ... Sarah has checked the cables and hard drives. ...
      (microsoft.public.cert.exam.mcse)
    • pqv소박한 꿈@mBGRx
      ... O-009바▣ MS Windows 2000 Datacenter Server -2만원 ... Main Application (Borland C++ Builder 6 Enterprise Edition) ... Y-166▣ Sex Starved Sluts 1 (Divx) ...
      (FreeBSD-Security)