SQL Server Performance

OLE DB error when I failover cluster

Discussion in 'SQL Server Clustering' started by mcdonaja, May 9, 2007.

  1. mcdonaja New Member

    Running windows 2003 SP1 with SQL Server 2000 SP4. Upgraded Crystal Reports 11 to both servers, once completed, started to get OLE DB SQL SERVER errors on 1 of the Nodes.

    I have checked registry settings for permissions which may have been changed during CR upgrade.
    Re-install SP4 for SQL Server 2000.

    Still have the same problem....Possible next step is the re-install of SQL Server 2000

    Any thoughts ??????
  2. MohammedU New Member

    Is Cristal Reports installed on cluster sql servers?

    Can you provide complete error info...
    When are you getting OLEDB errors?

    Check your MS DTC security configuration and make network access is enabled...


    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  3. satya Moderator

    http://aspalliance.com/532?ref=devzone_netzone_thirdparty_aspalliance
    http://support.microsoft.com/kb/306518
    fyi too.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  4. mcdonaja New Member

    MohammedU,
    Thanks for the reply. Yes Crystal reports is installed on both nodes of the cluster. I find the following error in the event viewer.

    Error Source = Microsoft OLE DB Provider for SQL Server
    Error Description = [DBNETLIB]

    Microsoft OLE DB Provider for SQL Server (80004005): [DBNETLIB]

  5. satya Moderator

    Seen the above links, specifically KBA>

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Share This Page