Win 2003 cluster with mixed SQL versions

  • Hello,

    I think I understand this but I want to get some expert opinions.

    Is it possible to set up a Windows 2003 cluster that contains a SQL 2005 instance and a SQL 2008R2 instance? The instances would be separate cluster groups. I think this should work fine because Windows Clustering just sees the SQL instances as services. It does not care what SQL versions those services are. Have I got this right? thanks

  • I believe that you should be able to do this. I'm not sure why you would, but I think you can.

  • As long as all of the SQL cluster requirements are met there is no issue running different versions of SQL on the same cluster.

  • Not sure why you would still be setting up Windows 2003 clusters, but you can do it.

    Note that if you are installing both SSRS 2005 and SSRS 2008R2 you MUST install the 2005 version first. Once SSRS 2008 is installed it disables the SSRS 2005 option.

    Also SSRS isn't cluster aware, so you need to give some special consideration to how you install these.

    Cheers

    Leo

    Leo
    Nothing in life is ever so complicated that with a little work it can't be made more complicated.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply