SQL Server administration and T-SQL development, Web Programming with ASP.NET and Javascript, SAP Smartforms and ABAP Programming, Windows 7, Visual Studio and MS Office software

Kodyaz Development Resources

Development resources, articles, tutorials, samples, codes and tools for .Net, SQL Server, Vista, etc.

Articles

News

IT Jobs

Software Development

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

Hello,

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

Comments

	Eralper's Blog on Software Development : Can not Upgrade SQL … - sql said: PingBack from http://sql.darmowe-blogi.pisz.pl/bez-kategorii/eralpers-blog-on-software-development-can-not-upgrade-sql.html May 11, 2010 10:53 AM
	eralper said: Hello, I got an answer from Microsoft Connect via Max Verun about upgrading to Microsoft SQL Server 2008 R2 Evaluation edition from MS SQL Server 2008 SP1. Here is the reply from MS Connect - SQL Server : "This is not a supported scenario and is expected to block. You cannot upgrade to Evaluation edition." So it is not supported to upgrade a developer edition or any other edition of MS SQL Server 2008 with or without SP1 (Service Pack 1) to MS SQL Server 2008 R2 Evaluation version. So a side by side installation of SQL Server 2008 SP1 and SQL Server 2008 R2 should be preferred or a clean installation of SQL Server 2008 R2 will be best for evaluation versions of MS SQL Server. May 12, 2010 2:02 AM
	Twitter Trackbacks for Eralper's Blog on Software Development : Can not Upgrade SQL Server 2008 SP1 to SQL Server 2008 R2 [kodyaz.com] on Topsy.com said: PingBack from http://topsy.com/trackback?utm_source=pingback&utm_campaign=L1&url=http://www.kodyaz.com/blogs/software_development_blog/archive/2010/05/11/21001.aspx May 12, 2010 11:28 AM

Anonymous comments are disabled

About eralper

Worked with Vignette , developed Tcl/Tk

This Blog

Post Categories

Syndication

Software Development

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

Comments

Eralper's Blog on Software Development : Can not Upgrade SQL … - sql said:

eralper said:

Twitter Trackbacks for Eralper's Blog on Software Development : Can not Upgrade SQL Server 2008 SP1 to SQL Server 2008 R2 [kodyaz.com] on Topsy.com said:

About eralper