Active-Active clustering vs Active-Passive clustering
For sql clustering (active-active) what changes do I need to make which are not used in active-passive clustering. I checked in a video that showed the same installation for active-active and active-passive. Please help.
If you open failover cluster manager, I take it you can see both nodes and both SQL instances? If so, and everything is properly setup, then you do have a multi-instance ("active/active") failover cluster and SqlInstance1 will automatically move to SQlCLuster2 when SQlCLuster1 fails. You can test this within failover cluster manager by manually triggering a failover from of SqlInstance1 from SQlCLuster1 to SQlCLuster2. Within failover cluster manager, select the "Roles" from the left then right click your instance in the central pane and select "Move" you just "Select Node..." and move it to the other node.