Consider a case where there is a pre-existing SQL Server 2000 Enterprise Edition 2-node cluster. Could a SQL Server 2005 or 2008 Standard be installed on the same cluster hardware, also in a clustered configuration? What are the constraints, limitations, caveats, and requirements for doing so? Thanks!
According to this white paper you can install 2000, 2005 and 2008 side by side in a cluster, as separate instances.
One caveat is that you must have SQL 2000 SP4 installed.
Yes it can. The constraints are that the SQL 2005 instance needs it's own Cluster IP and disk resources, so you set up a separate cluster group for the 2000 and 2005 instances. But they can share the same quorum, and obviously run on the same physical hardware.
