asked on

Unable to upgrade SQL 2008 Standard to SQL 2008 R2

Hi, I am working on a Windows 2008 R2 server and have SQL 2008 Standard edition installed. I wanted to upgrade to SQL 2008 R2 but when I get to the part of the upgrade where I must select the instance to modify it will not allow me to select my default MSSQLSERVER instance. I try to click the "Select All" button but nothing checks. I have to cancel out because I cannot go any further. So I thought maybe if I installed SQL 2008 SP3 and then I could go from there to R2. SQL 2088 SP3 installed successfully but I am still unable to upgrade to R2 with the same symptom. Any help would be great. Thanks.

David Todd

Hi,

Silly question time, but can you post the results of

select @@servername, @@version

My results are

-------------------------------------------------------------------------------------------------------------------------------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
######\SQL2008R2 Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64)
      Jun 28 2012 08:36:30
      Copyright (c) Microsoft Corporation
      Enterprise Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: )

(1 row(s) affected)

HTH
David

deviprasadg

According to MSDN http://msdn.microsoft.com/en-us/library/ms143393(v=sql.105).aspx

you can upgrade from
SQL Server 2008 Standard TO SQL Server 2008 R2 Standard, SQL Server 2008 R2 Enterprise, SQL Server 2008 R2 Datacenter

(This SQL Server edition can be upgraded to SQL Server 2008 R2 on the 32-bit subsystem (WOW64) of a 64-bit server. )

Download Microsoft® SQL Server® 2008 R2 Upgrade Advisor.
Microsoft SQL Server 2008 R2 Upgrade Advisor analyzes instances of SQL Server 2000, SQL Server 2005 and SQL Server 2008 in preparation for upgrading to SQL Server 2008 R2. Upgrade Advisor identifies feature and configuration changes that might affect your upgrade, and it provides links to documentation that describes each identified issue and how to resolve it.

X86 Package : http://go.microsoft.com/fwlink/?LinkID=188397&clcid=0x409
X64 Package : http://go.microsoft.com/fwlink/?LinkID=188398&clcid=0x409
IA64 Package: http://go.microsoft.com/fwlink/?LinkID=188399&clcid=0x409

Refer:
http://msdn.microsoft.com/en-us/library/ms143506(v=sql.105).aspx
http://www.microsoft.com/en-us/download/details.aspx?id=16978

jwhmack

ASKER

Hi, David

Thanks for your reply and I do not think that is a silly question. It is always best to be thorough. Here are the results of the query:

XXXXXXXXXX\Microsoft SQL Server 2008 (SP3) - 10.0.5500.0 (X64) Sep 21 2011 22:45:45 Copyright (c) 1988-2008 Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

ASKER CERTIFIED SOLUTION

jwhmack

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

jwhmack

ASKER

Because I was able to validate the solution via research and no one else had provided an answer yet.