SQL Server 2000 MSDE and XP sp2 problem

From: Thomas Phaneuf (tphaneuf_at_yahoo.com)
Date: 10/01/04

  • Next message: Roger James Jr: "Please Help with Transaction + Alter Procedure statement" 
    Date: Fri, 01 Oct 2004 00:47:45 GMT

    To all,

    After installing Windows XP SP2, a new problem was created in Enterprise
    manager. When you select a table and try to view the rows, the message
    "Provider cannot be found. It may not be properly installed."

    This occurs regardless of all the fixes that I have tried as posted by
    Microsoft. Unfortunately, the best advice that Microsoft has posted seems to
    be "Do not install XP Service Pack 2 if you are running MS-SQL Server".
    Unfortunately, I managed to miss that warning since I have been dutifully
    keeping my stuff updated on a regular basis.

    When I try to uninstall XP SP2 from the Control Panel, I get an error saying
    that it has already been uninstalled -- which is not true at all.

    Have tried reinstalling MDAC drivers. 2.8 won't install, 2.7 refresh will.
    All to no avail.

    Have also tried turning off the XP firewall -- both by using the interface,
    and also by disabling the service, but that has not effect. As a side
    note -- I already use a good firewall configured well. I REALLY don't want
    the XP firewall even on my system in any form or fashion. During all my
    efforts to correct this problem, my other firewall has been disabled as
    well.

    If ANYONE knows of a fix, or has experienced the same problem, to solve this
    (please don't suggest things that you haven't personally tried), please post
    the fix here -- or at least what you have tried and what doesn't work.

    Thanks in advance,
    -Tom 

    ---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.771 / Virus Database: 518 - Release Date: 9/28/2004
  • Next message: Roger James Jr: "Please Help with Transaction + Alter Procedure statement"

    Relevant Pages

    • Re: WXP SP2 Firewall not started
      ... The firewall cannot be started manually, ... this is to run a WXP SP2 repair. ... repair but then it suddenly lost the network connection again. ... And right click on the network connection and then try to install ...
      (microsoft.public.windowsxp.general)
    • Re: Download.com being blocked
      ... do was download XP SP2 so I could GET the firewall loaded and running. ... applied, unless I wanted to install Linux on it, which I didn't. ... SP2 on it if your original XP cd dosn't have it on it. ...
      (alt.sys.pc-clone.dell)
    • Re: OE Outbox fails after SP2 wireless cable
      ... that shortly with an SP2 download and install. ... I had a variety of problems that seemed to result from SP2, ... The hardware firewall in my linksys gateway is ... WS_FTP Pro as an exception for the firewall (presumably to allow it to upload ...
      (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
    • Re: Windows Xp Firewall
      ... I have a XP Pro with SP2 Install now but there another problem of Norton ... upgrade the Norton Anti-Virus personel firewall software that I don't know ... weather if this will mess up the XP SP2 firewall system block up the net both ...
      (microsoft.public.windowsxp.general)
    • Re: Virus infection as soon as Im online! Help
      ... I'm downloading SP2 & AVG updates at work now! ... even before I install the Broadband components. ... compared to the firewall with SP2. ... firewall and then whilst you download all the service patches for your XP ...
      (microsoft.public.security)