Avatar of matts22
matts22 asked on

SQL Cluster 2nd Instance Installation

At a high level what are the steps to install a 2nd instance of SQL 2k8 in a two node active/passive windows 2008 R2 Cluster?

Please verify they are:

1)  Setup a new disk that will be shared between the two nodes

2)  Under storage add the new disk into the cluster on node 1

3)  Run SQL 2k8 setup and install on the first node, the instance root directory will be C: (different dir from the 1st instance) but the data directory will be installed on the new disk I added to the cluster

4)  Than run setup on the 2nd node but choose "add node to sql server failover cluster" at the beginning of setup, than go through and do the same, select drive C: for the root directory and the new disk for the data directory.

The part I'm unsure about is #4 - because this is a 2nd instance I'm not sure if I choose add node.  Also would I fail over the 1st sql instance to the 2nd node before installing sql again?  

If you could clarify the install procedure on the 2nd (passive) node that would be great.

Microsoft SQL Server 2008Windows Server 2008

Avatar of undefined
Last Comment

8/22/2022 - Mon
Ryan McCauley

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question

So even though sql is already installed on the first and second node when I run the installer on the 2nd node it will detect the instance already on that node?

Incomplete answer
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes