Re: SQL Server 2000 MSDE and XP sp2 problem

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

  • Next message: l;kdf[poiqwt: "SQL Server newbie has questions" 
    Date: Sat, 02 Oct 2004 08:07:57 GMT

    > Problem summary: 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."

    David,
    Thank you -- I have seen that and have been through all the steps (spent
    literally hours messing with it). Am not using named pipes, and there
    doesn't seem to be a port or firewall issue -- at least nothing that is
    configurable. Have configured firewall to be off, and have even tried
    disabling the firewall service entirely -- neither with any effect on the
    problem. Am very frustrated with this issue.

    I saw reports of this same problem on the internet, so I know that it isn't
    unique to me -- but have not yet seen anybody report on being able to solve
    this problem. This happens both with local data and with remote data.
    Everything else can see the data (query analyzer, ado.net, ado, ole db,
    odbc), but just not in the Enterprise Manager.

    As a side note, I also have the .NET 1.1 framework SP2 installed. That
    caused it's own set of problems as well - but that is for another post. I
    don't think that it is related to this problem, but I am out of ideas.

    If anyone has run across this problem and solved it -- please post the
    solution...

    -Tom

    "David Portas" <REMOVE_BEFORE_REPLYING_dportas@acm.org> wrote in message
    news:78qdnWB9xdOKLMDcRVn-sA@giganews.com...
    > Have you seen the information in these articles?
    > http://support.microsoft.com/default.aspx?scid=kb;en-us;841249
    >
    > --
    > David Portas
    > SQL Server MVP
    > --
    >

  • Next message: l;kdf[poiqwt: "SQL Server newbie has questions"

    Relevant Pages

    • Re: my windows XP keeps on crashing!!!!!!!!!!!!
      ... After installing windows you MUST turn on the firewall before going on the ... > search web withing 1 minute computer crashed, ... Have no clue, except firewall, good luck. ... >>Internet and all of the sudden it crashed! ...
      (microsoft.public.windowsxp.newusers)
    • Re: replace hard drive - IMPORTANT
      ... Both Sasser and Blaster worms enter through open ports on ... reinstalling their firewall or turning on the XP firewall. ... >>internet connection, DSL or cable. ... >>3) After installing Windows install your firewall and anti-virus software. ...
      (microsoft.public.windowsxp.customize)
    • Re: MSSQL$MSFW :: How to connect to it with SQL Server Enterprise Manager?
      ... > The question is - can I connect to this instance with either SQL Server ... The firewall MSDE is a SQL 2000 instance. ... W3WALL\MSFW as the SQL Server in Enterprise Manager. ... Install the client tools on the firewall, login as ...
      (microsoft.public.isaserver)
    • RE: SP2 w/ linksys wireless-g failure
      ... > We have been installing Windows XP pro. ... > which I still have but my brother does not. ... > been able to get my connection back, ... When he restarted the firewall was there. ...
      (microsoft.public.windows.mediacenter)
    • Re: replace hard drive - IMPORTANT
      ... internet connection, DSL or cable. ... After installing Windows install your firewall and anti-virus software. ...
      (microsoft.public.windowsxp.customize)
    Loading