SQL Server Performance

Active/Active Cluster Installation Failed

Discussion in 'SQL Server Clustering' started by alimmia, May 8, 2007.

  1. alimmia New Member

    Hi All,
    I am trying to install active/active two nodes cluster (Windows Server 2003/SQL Server 2000 – sp3). I had successfully install the first instance. But the name instance failed. “Error: The cluster resource failed to come online.”
    Also, I did not see any option to choose log file location (only able to choose data file location). Would you please give me some hints?
    For the first instance, I named the first virtual server as SQLVR1 and the first instance as default.
    For the second virtual server, do I have to name it as SQLVR1xxxxxx? Can I give the virtual server and the name instance same name or they have to be different?

    Thanks,
    Alim


    Alim Mia
  2. satya Moderator

    You can let each node hosts two instances if it has enough horsepower. No matter how many nodes in the cluster, each instance needs its own set of disks.

    Few links on Active/Active clustering:
    http://www.sql-server-performance.com/bm_cluster_sql_server_2005.asp
    http://www.sql-server-performance.com/faq/sqlviewfaq.aspx?faqid=105
    also KBAhttp://support.microsoft.com/kb/883732 fyi on trying it back.

    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.
  3. alimmia New Member

    Thanks satya for the comments. You are right, I think I should go with active/passive configuration which is much easier.
    Thanks!


    Alim Mia
  4. satya Moderator

    I don't mean that to go with Active/Passive, you should think about such high availability option for your business case. If it is ok then A/P is good to go and A/A just gives additional option of live node.

    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.
  5. MohammedU New Member

    Check the setup file for more details...

    I believe your second instance should not be SQLVR1xxxxxx, it should be SQLVR2xxxxxx (SQLVR2 second virtual name)...


    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  6. alimmia New Member

  7. satya Moderator

  8. MohammedU New Member

Share This Page