Active/Active Cluster Installation Failed | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Active/Active Cluster Installation Failed

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
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.
Thanks satya for the comments. You are right, I think I should go with active/passive configuration which is much easier.
Thanks!
Alim Mia
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.
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.

Thanks MohammedU for the comments. Before I install the second instance, I must create the server alias. seehttp://support.microsoft.com/?id=815431 Alim Mia
KBAhttp://support.microsoft.com/kb/254321 fyi. 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.
quote:Originally posted by alimmia Thanks MohammedU for the comments. Before I install the second instance, I must create the server alias. seehttp://support.microsoft.com/?id=815431 Alim Mia

Yes,…
Check the following too…
http://www.sql-server-performance.com/rn_sql_server_clustering_2000_to_2005.asp MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.

]]>