SQL 2000 SP4 Enterprise on Windows 2003 SP1 Enterprise Cluster

Discussion in 'Clustering' started by Bruce Sarte, Aug 12, 2005.

  1. Bruce Sarte

    Bruce Sarte Guest

    I have set up Win2k3 clustering and am trying to cluster the SQL Servers on 2
    boxes and cannot. When I go to Add a Resource, SQL does not show up in the
    list... I have done this in Win2k with no problem before.

    The drives cluster fine, the NICs, network and IP address are fine...

    What am I missing? Any help would be greatly appreciated!
     
    Bruce Sarte, Aug 12, 2005
    #1
    1. Advertisements

  2. Rodney R. Fournier [MVP], Aug 12, 2005
    #2
    1. Advertisements

  3. You must perform a SQL Server install to both / all nodes of your cluster.

    Start here:

    SQL Server 2000 Failover Clustering
    http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx

    Appendix B - Step-By-Step Installation Instructions for a New Virtual Server
    http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/failclus.mspx#EDAA

    The second link is within the first reference and contains fantastic
    step-by-step directions with screen shots...While this is done on Windows
    2000, the basics are the same. Remember that with W2K3, Clustering doesn't
    need to be installed, it's already there! (Bonus!)

    Hope this helps,
    --Ryan

    --
    Ryan Sokolowski
    MVP - Windows Server - Clustering
    MCSE, CCNA, CCDA, BCFP
    Avanade
    http://www.Avanade.com

    "A troubleshooter's best tool is the Event Viewer and understanding the
    events and messages contained therein."

    This posting is provided "AS IS" with no warranties, and confers no rights.
     
    Ryan Sokolowski [MVP - Avanade], Aug 12, 2005
    #3
  4. When Ryan says "Remember that with W2K3, Clustering doesn't need to be
    installed, it's already there! (Bonus!)" You still have to install
    Clustering first, then SQL - it's just that with W2K3 you don't add the
    service, you simply create a cluster and go (I know you knew this, cause
    your cluster is already up, but you just knew know who reads this stuff).

    Cheers,

    Rod

    MVP - Windows Server - Clustering
    http://www.nw-america.com - Clustering Website
    http://msmvps.com/clustering - Blog
    http://www.clusterhelp.com - Cluster Training
    http://msmvps.com/clustering/archive/2005/07/20/58233.aspx NYC Clustering
    class
     
    Rodney R. Fournier [MVP], Aug 12, 2005
    #4
  5. Yep, Rod's clarification is right...That's why I said "You must perform a
    SQL Server install to both / all *NODES* of your *CLUSTER*."


    --
    Ryan Sokolowski
    MVP - Windows Server - Clustering
    MCSE, CCNA, CCDA, BCFP
    Avanade
    http://www.Avanade.com

    "A troubleshooter's best tool is the Event Viewer and understanding the
    events and messages contained therein."

    This posting is provided "AS IS" with no warranties, and confers no rights.
     
    Ryan Sokolowski [MVP - Avanade], Aug 12, 2005
    #5
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.