Upgrade rules problem when trying to upgrade from SSE 2005 to SSE 2008

Question

Hi

I'm currently using SSE 2005 with Visual Studio 2008, and now I want to upgrade SSE 2005 to SSE 2008.

I have downloaded SSE 2008 and then using the SQL Server Installation Centre I selected Installation, followed by Upgrade from SQL Server 2000  or SQL Server 2005.

I've then progressed through the wizard until Upgrade Rules and then I get 1 failed operation, being SQL Server Feature Upgrade "Failed".

The System Configuration Check Report refers to Upgrade checks for rules group "UpgradeFeatureSpecificRules and FeatureUpgradeMatrix Check and then states "The Specific edition upgrade is not supported.

I have run the SQL Sever Upgrade Advisor and I get 1 warning Location StartUp/Enabled Trace Flag 8017.  The help says "we recommend that you disable all trace flags".

I don't really have any idea how to progress from here and how to correct the errors as I don't understand them. 

Any help in achieving the SSE 2008 upgrade would really be appreciated.


Chris

 

Answer 1

In this case the error message is typically exactly correct; the edition of SQL 2005 you have installed is not supported for upgrade to the edition of SQL 2008 you're trying to install. The most common cause for this would be that you have SQL Server 2005 Express Advanced and you're trying to install SQL Sever 2008 Express Runtime. Generally you can move down the edition stack when upgrading, you have to move either side-ways (the same edition) or up.

You can check what edition you have installed either by running the SQL 2005 installer maintenence mode and clicking the Report button or running "select @@version" from your favorite sql client.

Regards,
Mike

---

If this post answers your question, please mark it as an Answer - it will help others searching the forum. This posting is provided "AS IS" with no warranties, and confers no rights.

Answer 2

Hi Mike

Many thanks for your reply.  I thought I originally installed SSE 2005, infact using select@@version as you suggest, I have SSE 2005 Advanced installed. 

I'm not sure that I need SSE 2008 Advanced, it's download size is 502MB as opposed to 89MB for SSE 2008 or 96MB for SSE 2008 with SP1.

As I do have SSE 2005 Advanced installed, what are my options.  Do I have to upgrade to SSE 2008 Advanced or can I uninstall SSE 2005 and install SSE 2008 to move down the edition stack.

Chris