• tcronin 95651 (9/20/2016)


    Going to do a upgrade from sql 2008 standard edition to sql 2008r2 on active/passive physical cluster. WHen finished wanted to upgrade the edition from sql 2008r2 standard to enterprise. Some of the MSDN articles seem to point out that this is not possible (and yes I know 2008r2 is ancient sorry 3rd party app play the cards you are dealt). This server is a BI server with 3rd party tool and has analysis server and reporting server on it. ANyone done an edition upgrade on an active/passive cluster?

    There's no SP required for 2008 to 2008 R2 upgrade.

    From memory you should just be able to run the 2008 R2 Enterprise installer directly and upgrade the instance on each node.

    Failing that, the path you mention is valid, note that the upgrade from Std edition to Ent edition is done once only on the node where the cluster group is running

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉