I have SQL Server 2008 Express Edition and I needed to upgraded to either Express Edition R2 or R2 Web edition.

So I ran the set up of R2 Web and go to the maintenance and select Edition Upgrade. Then I went thru the Wizard and inserted the key and Set up said the upgrade has completed.

But when I check in the Management Studio, it still shows as SQL Server 10.0.400.

So did it actually upgraded to R2 Web?


You're just looking at the version number, which does not change via an edition upgrade.

In SQL Server Management Studio, the key you're looking for is "Product"

enter image description here

  • Mine still shows as Express Edition – Ye Myat Aung May 14 '12 at 4:23
  • @YeMyatAung - in that case, the answer to your question So did it actually upgraded to R2 Web? is "no" – Mark Henderson May 14 '12 at 4:35
  • You might find the following question useful: serverfault.com/questions/304610/… - it turns out you cannot upgrade any edition to Web in-place. – Mark Henderson May 14 '12 at 4:36
  • Ok. Another question is, can I install a separate Web edition and attach database later? – Ye Myat Aung May 14 '12 at 4:36
  • @YeMyatAung - yes. You can install multiple copies of SQL Server side by side on Named Instances, and then move the database and update your connection strings. – Mark Henderson May 14 '12 at 4:38

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.