3

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?

Improve this question

1 Answer 1

Reset to default
4

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

Improve this answer
5
  • Mine still shows as Express Edition Commented May 14, 2012 at 4:23
  • @YeMyatAung - in that case, the answer to your question So did it actually upgraded to R2 Web? is "no" Commented May 14, 2012 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. Commented May 14, 2012 at 4:36
  • Ok. Another question is, can I install a separate Web edition and attach database later? Commented May 14, 2012 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. Commented May 14, 2012 at 4:38

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.