SQL Server administration and T-SQL development, Web Programming with ASP.NET, HTML5 and Javascript, Windows Phone 8 app development, SAP Smartforms and ABAP Programming, Windows 7, Visual Studio and MS Office software Kodyaz Development Resources
Development resources, articles, tutorials, code samples and tools and downloads for ASP.Net, SQL Server, R Script, Windows, Windows Phone, AWS, SAP HANA and ABAP, like SAP UI5, Screen Personas, etc.

Software Development

Can not Upgrade SQL Server 2008 SP1 to SQL Server 2008 R2


Microsoft has released SQL Server 2008 R2 for RTM use of SQL Server professionals.
I have downloaded SQL Server 2008 R2 Trial , the free trial download for 32 bit OS from Microsoft Downloads.

But I can not upgrade SQL Server 2008 SP1 to SQL Server 2008 R2 Evaluation edition.
The upgrade from SQL Server 2008 SP1 to SQL Server 2008 R2 fails when the Upgrade Rules are checked.
The upgrade rule "SQL Server 2008 R2 Feature Upgrade" fails and the detail message is as follows :

The specified edition upgrade is not supported. For information about supported upgrade paths, see the SQL Server 2008 R2 version and edition upgrade matrix in Books Online

Here is my current MS SQL Server 2008 SP1 instance information :

Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (Intel X86)
   Mar 29 2009 10:27:29
   Copyright (c) 1988-2008 Microsoft Corporation
   Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 3)

I think if I can find an indicator that marks the installed current SQL Server 2008 version as SP1 and change it as RTM version of MS SQL Server 2008, I can successfully upgrade from SQL Server 2008 SP1 to SQL Server 2008 R2

What do you think? Do you have similar problems during installation of Microsoft SQL Server 2008 R2 ?

Published Tuesday, May 11, 2010 4:43 PM


No Comments
Anonymous comments are disabled

About eralper

SQL Server administrator and T-SQL developer including BI components Web programming with HTML, HTML5 and ASP, ASP.NET and .NET Framework developer SAP ABAP and SAPUI5 development, Web Dynpro and Smart Form Siemens HiPath Center CTI development
Copyright © 2004 - 2020 Eralper YILMAZ. All rights reserved.
Community Server by Telligent Systems