• Post Categories

  • Browse Blogs

  • Blog Stats

    • 293,953 hits
  • Syndications

    SQLServerPedia Contributor

SQL Server Upgrade error: It is not possible to change the SQL Server features to be upgraded in this release. Validation errors. There are no features selected for upgrade.

On a recent project I was asked to “upgrade” a licensed SQL Server 2008R2 Standard Edition to SQL Server 2008R2 Enterprise Edition. I have done this multiple times with no issues. The “kicker” was that the upgrade required a 48-hour turnaround time but no installation media for SQL Server Enterprise was going to be available in that same timeframe due to a delay in the procurement process.

In order to meet project requirements and gain some time, a team member suggested we go ahead and do the “upgrade” using a downloaded copy of SQL Server 2008R2 Evaluation Edition since Evaluation Edition contains all the Enterprise features that were required. Once the installation media for SQL Server 2008R2 Enterprise arrived, we were to simply upgrade the Evaluation Edition to Enterprise Edition.

My immediate response was that going from a licensed edition to an evaluation edition was not possible. It is not a “natural” upgrade path and is actually considered a “downgrade” as you are going from a licensed edition to an unlicensed edition. As a professional I had to back this statement up with official Microsoft documentation. As a geek no matter what the documentation said I had to try it myself to see what happened. So I did both.

Documentation
A quick search of Books on Line on SQL Server 2008R2 led me to the following MSDN article titled “Version and Edition Upgrades” (http://msdn.microsoft.com/en-us/library/ms143393(v=sql.105).aspx) . This article is great as it outlines all the supported upgrade scenarios for all versions and editions of SQL Server. A quick scroll towards the bottom shows that the only two upgrade paths supported for Standard Edition is Enterprise and Datacenter. As a matter of fact this article shows that there is no support going from any other edition to Evaluation Edition.

Additionally, there are a couple of footnotes at the bottom. An important footnote to take a look at is footnote No. 2. Although the statements in footnote No. 2 are within the context of failover clusters, some of them also apply to stand-alone installations. In this footnote it is clearly stated that SQL Server 2008R2 Standard to SQL Server 2008R2 Evaluation upgrade is not supported.

Test

I wanted to see for myself the error message generated if I tried to carry out the upgrade anyways. Of course I did not try to do this on the actual client’s environment. That is a big no no! I decided to spin up my own sandbox virtual environment. The steps I followed on my test were:

  1. Install SQL Server 2008R2 Standard Edition (Database Services, Analysis Services, SSMS, BIDS)
  2. Reboot
  3. Upgrade SQL Server 2008R2 Standard Edition to SQL Server 2008R2 Evaluation Edition using the Upgrade Setup Wizard from Installation Center.

As I went through the Upgrade Setup Wizard I got the following validation error as expected:

In summary, you cannot upgrade from a licensed SQL Server edition to SQL Server Evaluation Edition. It is perfectly possible though, to upgrade from SQL Server Evaluation Edition to other licensed SQL Server editions. For more details on the supported upgrade paths refer to MDSN article: http://msdn.microsoft.com/en-us/library/ms143393(v=sql.105).aspx.

About these ads

One Response

  1. Bonjour SQL Joe,

    thank you very much for this post! Quite interesting! I ran into a similar failure to “Upgrade” despite the context being quite different. Unfortunately, my upgrade path is not listed on the Microsoft’s site you pointed to above. In our big Department we are quite behind in terms of versions and technologies and the process to get approval and QA for newer versions is overwhelmingly heavy so we are stuck with older versions.I installed SQL Express 2008 x86 (not R2) with Service Pack 3 on a client Windows XP (SP3) machine (database engine and core components only). According to MS download page, it was published on 2011-10-06.

    http://www.microsoft.com/en-us/download/details.aspx?id=27597

    Now I want to add the Tools (that is run Setup for SQL Server Express 2008 with Tools). Its download page says it was published the same date (and same version) as the initial release of Express 2008, on 2/8/2009:

    http://www.microsoft.com/en-us/download/details.aspx?id=22973

    Therefore, I would in fact be downgrading in terms of patches and updates unless the features I add to my existing installation are 100% independent of common files and core components already installed. I am quite surprised that Microsoft would have release a download of Express that includes the SP3 but no release of download of Express with Tools and with Advanced Services that would include the same SP3 update. The end results are that I get the same message as above. I tried both to Upgrade and to Add Features but to no avail. I also tried to upgrade to Advanced Services with the same failure. It makes no sense to me that one has to choose of getting EITHER the benefits of the SP3 OR the benefits of additional tools and services… The SP3 is not available separately, by itself… Anyway that was my two cents I could not hold inside anymore ;-)

    Thanks again for the post!

    Kindest Regards,

    Frank

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 1,639 other followers

%d bloggers like this: