Avatar of chandradineshbabu
Flag for India asked on

Multiple sql clusters on single windows cluster


I have a sql cluster(active/passive) on windows cluster which has two nodes.the current sql cluster we use for testing environment.we would like to install one more sql cluster on same windows cluster for stage environment.
1.Can we have multiple sql clusters(active/passive) on single windows cluster?
2.if it is eligible to install multiple sql clusters on single windows cluster what would be the process to go head with one more cluster installation?
3.what are the merits and demerits if we do so?
Microsoft SQL Server

Avatar of undefined
Last Comment

8/22/2022 - Mon

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

I have following questions:

For multiple instances
1.Do we need two sql groups with same windows cluster group?
2.Do we require SAN drives,Virtual sql IP,sql named instamce name for installation of one more sql cluster on same windows cluster?

Question 1:  Yes each SQL instances is a seperate SQL server.
Q 2:  Yes.

See 3rd post at the following link:

Excellent Link
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck