I am planning to setup 3 node clustering (Active/Active/Passive) in vmware workstation. so can anyone provide setup guide step by step.
For configuring Windows cluster on VMWARE please first read below article
For configuring SQL server cluster
1. After creating windows cluster install SQL server in cluster mode on node 1.
2. Then add node 2 using add node feature in installation
3. Then Add node 3.
4 Storage should be visible to all three node.
5.Active/active is old term what you are asking for is multiinstance cluster.Where node1 will host one application ,node 2 will host other and for failover you will use node3.
Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?