How to add SQL Instance to Cluster (2008)?

I have a 5 Node SQL Cluster. 4 nodes have SQL Server instances. 3 are active, and 1 is passive. I want to use the 5th Node for a SQL Instance - How do I go about configuring this?

SQL Cluster Config Screenshot
KThraceAsked:
Who is Participating?
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
You need to run the SETUP.EXE from SQL Server installation media and the chose the option to create a new clustered instance. Then just follow the wizard and don't forget to do the same for all nodes so you can failover to any node.
0
 
KThraceAuthor Commented:
Run setup.exe on all nodes? the Node is already added to the cluster though (Did you look at the image?)
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Yes, I look at the image but each SQL Server instance need to be installed and the only way to do it is running the setup.exe.
Who installed the actual SQL Server instances in that cluster?
0
Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Or I may misunderstood your question.
Please clarify if you want to install SQLServer Inst05 or do you want to make ACSQLNODE05 available for receive one of those 4 SQL Server instances?
0
 
KThraceAuthor Commented:
I actually have a SQL Server and database that I want to move to the failover cluster from a standalone SQL Installation... and use NODE5...
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Ok, you can do this in 2 ways:

1. Migrate the database

This option should be the easiest and fastest one since you just need to migrate the database you want into one of the 4 SQL Server instances that already exists.

2. Migrate the stand alone instance

This one it's more complex but maybe is the one that you are looking for and for this it requires a new SQL Server instance and for that you'll need to run setup.exe in all 5 nodes. And after create the new clustered instance you'll need to migrate the database(s) into the new SQL Server instance.
0
 
KThraceAuthor Commented:
Which option do I choose to install for a new SQL Server Instance?
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Ok, you chose to go for a new SQL Server instance. For that you need to have available storage. Do you have it? Should be new disks resources available in your cluster and can't be used by other SQL Server instances. This is a pre-requisite and you can't proceed with the new installation without have available disks (can't be local disks).
0
 
KThraceAuthor Commented:
Ok, I just provisioned a new LUN, added it to Failover Cluster Manager and it is in Available Storage now

Now I'm running SETUP on NODE05 first - choose the first option?
0
 
KThraceAuthor Commented:
SQL-options.png
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Good.
You'll also need a Virtual IP and a Virtual Network Name.
Then chose the 2nd option: "New SQL Server failover cluster installation" and follow the wizard.
For the next 4 nodes you need to chose the 3rd option: "Add node to a SQL Server failover cluster".
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
You can also follow these instructions since they show how to do it, step by step.
0
 
KThraceAuthor Commented:
Thanks for your help, appreciating it.

I get to the instance configuration screen and am aasked for a SQL Server Network Name for the failover cluster. I don't want to create a NEW cluster. Just add to the existing cluster....

Instance-Config.png
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
It's what I told you on my comment #a40746357.
Isn't to create a new Windows Cluster but SQL Server Instance in a Windows Cluster. So it's expecting something like INST05.
0
 
KThraceAuthor Commented:
Ok, looks like it was successful. I see it showing up now in Failover Cluster Manager as an instance.

So I should run this on all the nodes I'd like it to failover to and use "add an existing node" open for the install?
0
 
KThraceAuthor Commented:
Provided steps to resolution of issue.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
I'm glad that you could make it. Isn't hard but you need to remember that the pre-requisites are different from a stand-alone instance.

Cheers.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.