How do I setup a Active Active Cluster in Windows 2003?

I'm trying to setup a Microsoft Cluster Active Active for my employere.  Despite all the warnings about active active they still want to push forward.  This will be a 2 node cluster with identical hardware utilizing zoned san space.  The intial cluster is in place (Active Passive) I need to add the resources to the 2nd node.  I keep running into problems with differnt errors.  Is there a step by step guide on how to setup a active active.  I apologize for my lack of knowledge.  I've tried ot search the net for this information but have had little success.  I'm unsure on how the grouping should be setup.  I have 2 separate drives in different groups.  How does the quorum share or does it need to be listed in the 2nd node..  Eventially they will be using this cluster for SQL.  Any Help is appreciated.
jmatteolAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

StuFox100Commented:
I am not  100% clear on what you mean by adding "the resources to the 2nd node"? Are you trying to run the same DBs on both servers? If so this will never work.

Active/Active Clustered SQL is not quite what it means - the active/active means that both nodes are serving SQL but usually server different DBs. You split the backend disk between the nodes and load share - if you have a DBA they should help you decide what DBS are best suited to be together on what nodes.

The advantage is that when one of the nodes fails all services run of the other node and keeps working.

I hope this makes it clearer...
Cheers
Stu
0
jmatteolAuthor Commented:
Stu,

Thanks for the response.  To make things a little clearer.  We are setting up the cluster to turn over to SQL DBA's.  There will be 2 different Databases on this Active / Active Cluster.   In regards to setting up resources on the 2nd node.  I mean should there be a 2nd resource group for node 2 housing Network Name and IP Address so that the active active ends up with 2 Virtual Servers.  My problem in a nutshell happens when I try to add the Network Name to the 2nd node in a separate resource group for node 2.  

Thanks Again for your help.
jmatteol
0
jmatteolAuthor Commented:
It turns out due to deadlines we had to involve Microsoft.  The issue causing my problem was a corrupted group.  Once I deleted the corrupted group and recreated it everyting seemed to work just like normal.  Remember for a active active 2 node cluster you should have 3 virtual nodes.  1 that is created when you first create the cluster.  This will be be your Cluster adminstrator.  Then you will have 1 group that is set to only use resources on 1 of the nodes and then another group that is set to only use resources on the other node.   (Bear in mind this is a 2 node cluster) You will also have separate LUNS setup on your SAN so that you can define 2 separte disks.  Each of the separate disks will be separated by the groups.  After the 2 groups are defined in Cluster manager then adding the IP resources and network name for each group is a snap.  Then you will want to make sure to setup the preferred node for each group and the failback options.  At this point I was ready to turn my cluster over to a SQL DBA to setup the separate instances of SQL.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Server 2003

From novice to tech pro — start learning today.