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

Tags:
Clusters
SQL Server 2005
SQL Server clustering
SQL Server installation
Windows Server 2003
Windows Server 2003 SP1
What are the steps to install multiple instances of SQL Server 2005 on Windows Server 2003 SP1 cluster?
ASKED: April 30, 2008  5:23 PM
UPDATED: May 2, 2008  2:00 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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)
CLUST2\INSTANCE1
CLUST3\INSTANCE2
etc

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following