asked
Active/Active sqlserver 2008 on node1 and sqlserver2008 R2 on node2 cluster configuration
Hi All , My requirement is to Active/active cluster configuration , for sqlserver 2008 on node1 and sqlserver 2008 R2 on node2 , please help me how to setup this cluster and send me some links for reference if any one have will be appreciate.
MSDN is your best bet - there are a wide range of whitepapers and tutorials out there that can go into way more depth than is practical to provide as an answer here. Let me help you get started though: [How to install a SQL Server Cluster reference materials][1] I can't imagine a mixed version Active Active cluster really being such a good idea though. I would stick to either all 2008 or all 2008R2 [1]:
http://lmgtfy.com/?q=sql+server+2008+cluster+installation
You can have a cluster running different versions, but not each node if you wanted the cluster to act as a failover cluster. Just as a single machine can run a 2000, a 2005, a 2008 and a 2008R2 instance, a single cluster can do the same, but if the 2008R2 node failed, and the other node only had 2008, then it wouldn't be a failover cluster. Why do you want to have different versions on each node?
You should be even mix SQL Server 2005 with SQL 2008, I don't see any problem this will not work. As for Kevin Riley's question "Why do you want to have different versions on each node?", the reason is that not all vendor applications will be compatible to same version of SQL Server. Sometimes, you do have to mix versions on same cluster.
