Link to home
Start Free TrialLog in
Avatar of KThrace
KThrace

asked on

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?

User generated image
ASKER CERTIFIED SOLUTION
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of KThrace
KThrace

ASKER

Run setup.exe on all nodes? the Node is already added to the cluster though (Did you look at the image?)
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?
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?
Avatar of KThrace

ASKER

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...
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.
Avatar of KThrace

ASKER

Which option do I choose to install for a new SQL Server Instance?
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).
Avatar of KThrace

ASKER

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?
Avatar of KThrace

ASKER

User generated image
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".
You can also follow these instructions since they show how to do it, step by step.
Avatar of KThrace

ASKER

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....

User generated image
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.
Avatar of KThrace

ASKER

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?
Avatar of KThrace

ASKER

Provided steps to resolution of issue.
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.