I want to set up a 4 node cluster where 3 nodes are active and 1 is the
passive node that would take over in case any one of those 3 active nodes
fail. How can I set this up ? Any documentation..

Using SQL 2005..

[quoted text, click to view]

First, you get the proper training...

Basically, you build the four node cluster then install SQL three times to
create three instances with each instance hosted in its own resource group.
Place a SQL instance on each node that you want to be the active node.


--
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp

The next ClusterHelp class is:
April 30, 2007 - Denver

You can find a lot of documentation on MSDN about this. Setting up clustering
is a very eloborate process and you need to prepare a lot before actually
setting one up.

All the best.

Suresh

[quoted text, click to view]