How to install a passive node on an active/active SQL Server cluster

Tags:
Installation
SQL Server 2005
SQL Server availability
SQL Server clustering
We have a SQL cluster server running with SQL Server 2005 Enterprise Edition SP2 on Windows 2003 Enterprise Edition. Currently the cluster has 2 nodes with Active/Active. Now I need to add a new node as a Passive node. So once I’m done, the cluster will be a Active/Active/Passive cluster. Because the cluster is a production server, I need to know exactly how I can add a new node onto the current cluster without breaking anything. Also this is my first time installing a passive node, so it is difficult for me to understand how to install and configure it.

Answer Wiki

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

First you need to add another node into the Windows cluster. This is done with the Cluster Administrator. Run through the wizard to add the machine into the cluster. Your Windows admin can probably do this for you.

After the machine is part of the cluster, run through the SQL installer again and it will give you the option to push the service to the new machine in the cluster. You will need to do this twice, one for each instance. After then you’ll need to patch both instances again to the same patch level you are on currently.

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