Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question

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

share|improve this answer
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:… - 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 posting your answer, you agree to the privacy policy and terms of service.

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