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've upgraded SQL 2008 to R2 and the SQL Server Management Studio is showing 2008 R2, but whenever I connect to the SQL instance, it's displaying 10.0.2531 instead of 10.50.1600. Any idea on how to upgrade to the newer version?


share|improve this question
You definitely ran the upgrade on the server hosting the instance, not just a PC running Management Studio? – MartW Dec 1 '10 at 8:38
Did you add a new instance rather than upgrading the existing one? – MattB Dec 1 '10 at 15:49
I think I upgraded the existing one. – Saxman Dec 1 '10 at 18:47

where exactly is displayed 10.0.2531?

run thiss against the server you say you upgraded:

select SERVERPROPERTY('ProductVersion')

It should display 10.50.1600.1. If it doesn't then maybe you upgraded client tools or other SQL tool than SQL engine.

share|improve this answer

I encountered the similar issue, when trying to attache an .mdf files that was created on another machine running SQL Server 2008 R2 Express, to the SQL Server 2008 R2 Express on my machine..

I did install 2008 (non-R2) and then 2008 R2 on my machine.

After spending hours googling to find a solution, eventually unsuccessful, I simply decided to download the installer 'SQLEXPR_x64_ENU.exe' from and run it again, hoping it would solve (Windows 7 64 bit)

On the installation Wizard under 'Installation', I selected 'Upgrade from SQL Server 2000, SQL Server 2005 or SQL Server 2008' and continued to press Next until it disappeared (Obviously you will have to wait until it finish processiong each step).

That's it. I was able to attach the same file..

share|improve this answer

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.