How to install second instance in Act/Pas CLuster | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

How to install second instance in Act/Pas CLuster

I have just setup MSSQL 2005 in an Active/Passive Cluster mode running on Windows 2003 server. Now i have a request to setup a second Named Instance on the same cluster. I am looking for a document that would outline the procedure which will include the prerequisites.
The thing that I am worried about is that i read somewhere that each instance will need its own shared disks. If this is true , I will need to rearrange my Storage on my SAN which is cumbersome. I am hoping its not soo complicated. I hope I can use the same shared disks.
I also read about having to setup the Alias using Network Configurator ( SQL 2000) else the installation will fail.
To clarify all these doubts and to setup up the 2nd instance correctly, I would be glad if anyone here could direct me to where I could find good documentation to that effect. Thanks
Victor
You don’t need to create the alias like in sql server 2000…
You can do the regular installation…
Do not use the same disks…
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.
Hi Mohammad,
thank you for the prompt reply,
what do u mean dont use the same disks…I am guessing I will need only the Data Disk right, and that I can use the same Quorom ,Log and MSDTC disks? why cant i use the same disks ?
I mean. if i want the instances to move together across my nodes, why not ?(i am in active/passive cluster mode)
unfortunately i am a newbie with MS clustering . so am learning right now.I have experience with some UX clustering and
any hints u provide will speed up the process
an installation doc would be perfect.. thanks Victor
http://www.sql-server-performance.com/bm_cluster_server_2003_02.asp 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.
]]>