troubleshooting Question

Need to set up virtual active - active - passive SQL Server cluster

Avatar of jflanner
jflanner asked on
Windows Server 2003Storage Software
2 Comments1 Solution358 ViewsLast Modified:

I have a four processor box running Microsoft virtual server 2005.  I need to set up four Windows server 2003 - SQL server 2000 virtual machines on this box.  Three of these virtual machines I need to cluster in an Active - Active - Pssive scheme.  (The passive box will take over for either failed machine.)  My goal is to use this environement as a production image on which to conduct systems testing for migration to SQL Server 2005.

I am finding several articles on implementing active - passive clustering in a virtual environment; but nothing on active - active - passive.  Also - my systems engineer believes that only 2 node clustering is supported in VM.  I have not seen that from Microsoft and do not believe it to be true.  But nor have I found it from Microsoft that it can be done.

Does anyone have any ideas on this??  Can you point me to literature on how to set it up??  

Thanks.  Much appreciated.
Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros