What are the steps to install multiple instances of SQL Server 2005 on Windows Server 2003 SP1 cluster?
What are the steps to install multiple instances of SQL Server 2005 on Windows Server 2003 SP1 cluster?

Software/Hardware used:
ASKED: April 30, 2008  5:23 PM
UPDATED: May 2, 2008  2:00 AM

Answer Wiki:
For each instance you wish to setup you need to create a separate Resource Group within the cluster resource manager. As each instance needs its own resource group you'll need a static IP address, unique hostname and LUN for each resource group (at least 1 LUN). (Yes each instance needs its own unique hostname on the network.) After you have created a resource group and created the storage resource for the LUN within it, as decided on the hostname and IP Address you'll be using you can get started. Run through the installer just like installing the default instance on the cluster. Instead of selecting the default instance, enter the instance name. Give it the unique IP Address and hostname of the instance. Then run through the rest of the install wizard. It will install on the other nodes just like installing the default instance. After installing your instances will look something like this. CLUST1 (The Default Instance) CLUST2INSTANCE1 CLUST3INSTANCE2 etc
Last Wiki Answer Submitted:  May 2, 2008  1:55 am  by  Denny Cherry   64,550 pts.
All Answer Wiki Contributors:  Denny Cherry   64,550 pts. , Spadasoe   5,130 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _


 

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

 64,550 pts.