Solved

Installing 2nd instance on multi-instance sql 2008 cluster

Posted on 2011-03-07
5
785 Views
Last Modified: 2012-05-11
We are installing a mulit-instance sql server 2008 cluster.  If we install the failover cluster on node a and then install the add node to node b - what is the next step?  Should we add the second instance to node a even though we want it to run on node b (and then I guess change the preferred node in cluster admin) or do we add the second instance on node b and then install the add node on the other server?  Alos, are there any other options to consider - possibly installing both instances first and then installing the add node feature of both afterwards?  Are there any other things to consider with this type of install?
0
Comment
Question by:PiedmontHealth
  • 3
  • 2
5 Comments
 
LVL 8

Expert Comment

by:dba2dba
ID: 35061236
Below would be the steps:

1) setup the Node A as a single node windows cluster and install SQL Server
2) Add the node B to the current single node cluster
3) run setup on the second node and it will promt you to select whether it is a new sql installation or adding node to existing instance. you need to select the appropriate existing instance.

The behavior is Step3 is new to sql 2008. You need to install sql in both nodes in sql 2008 which is not the case in earlier versions.

IMO, this is the only way to perform this task.

THanks,
0
 

Author Comment

by:PiedmontHealth
ID: 35061316
Yes, but now I want to add a second instance of SQL to the cluster.  Node A will run one instance and node B will run the second instance (unless of failover in which case both instances will run on one).  My question is:  when I install the second instance of SQL, do I start on Node B (since that is where it will primarily run) or do I start on Node A (since that is where I started the initial install of the first SQL instance?
0
 
LVL 8

Accepted Solution

by:
dba2dba earned 500 total points
ID: 35061528
It will not matter where you start the Install, you can start on any instance of your choice. Once the install is complete you can failover to desired node if needed.

Thanks,
0
 

Author Closing Comment

by:PiedmontHealth
ID: 35110856
The solution was accurate but more elaboration would have been helpful.  I didn't feel totally comfortable and ended up talking with someone at Microsoft who elaborated that I should install the first instance completely (both nodes) and then install the second instance.   It didn't matter which node I started the second instance on.  I had also requested to know if there were other concerns with this type of install - and of course there were, but no mention of this part of the question in the response.
0
 
LVL 8

Expert Comment

by:dba2dba
ID: 35111924
PiedmontHealth: - Thanks for the feedback. I will try to be more elaborate in my replies. Also, Please don't hesitate to ask for a more elaborate answer if needed - Thats what I do with the questions I post too.
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question