dbTalk Databases Forums  

Cannot upgrade SQL Server 2008 Standard to Enterprise

microsoft.public.sqlserver.setup microsoft.public.sqlserver.setup


Discuss Cannot upgrade SQL Server 2008 Standard to Enterprise in the microsoft.public.sqlserver.setup forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Microsofted
 
Posts: n/a

Default Cannot upgrade SQL Server 2008 Standard to Enterprise - 04-29-2010 , 10:13 AM






I have installed a named instance of SQL Server 2008 Standard Edition (RTM)
on Windows 2008 Server Standard Service Pack 2. When I attempted to upgrade
the instance to SQL Server 2008 Enterprise Edition by running setup.exe, the
following error occurred:
The selected SQL Server instance does not meet upgrade matrix
requirements.

However, I have inspected the upgrade matrix in Books Online under "Version
and Edition Upgrades," and all seems correct. Since an MSDN license is being
used, the PIDs are the same for both editions.

Reply With Quote
  #2  
Old   
Erland Sommarskog
 
Posts: n/a

Default Re: Cannot upgrade SQL Server 2008 Standard to Enterprise - 04-29-2010 , 04:39 PM






Microsofted (Microsofted (AT) discussions (DOT) microsoft.com) writes:
Quote:
I have installed a named instance of SQL Server 2008 Standard Edition
(RTM) on Windows 2008 Server Standard Service Pack 2. When I attempted
to upgrade the instance to SQL Server 2008 Enterprise Edition by running
setup.exe, the following error occurred:
The selected SQL Server instance does not meet upgrade matrix
requirements.

However, I have inspected the upgrade matrix in Books Online under
"Version and Edition Upgrades," and all seems correct. Since an MSDN
license is being used, the PIDs are the same for both editions.
I don't know if there is anything special for MSDN license, but I have
not heard of any.

But just a stupid check, you are not trying to upgrade from x86 to x64,
are you? That is not supported.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Reply With Quote
  #3  
Old   
Jeffrey Williams
 
Posts: n/a

Default Re: Cannot upgrade SQL Server 2008 Standard to Enterprise - 04-29-2010 , 07:50 PM



You can't upgrade an existing Edition by running setup.exe. You have to
perform an SKUUPGRADE as outlined in this article:
http://msdn.microsoft.com/en-us/libr...9(SQL.90).aspx

Example would be something like:

start /wait setup.exe ADDLOCAL=SQL_Engine INSTANCENAME=MSSQLSERVER
UPGRADE=SQL_Engine SKUUPGRADE=1 /qb

Review the document carefully, and make sure you upgrade all components - as
this will only upgrade the specified components in the command. I did this
before, and you can be prompted for the dialog boxes if you include the /qb
and leave off the other parameters. I don't recall which ones are
required - so try different combinations to get the right options in the
dialog boxes.

Jeff

"Erland Sommarskog" <esquel (AT) sommarskog (DOT) se> wrote

Quote:
Microsofted (Microsofted (AT) discussions (DOT) microsoft.com) writes:
I have installed a named instance of SQL Server 2008 Standard Edition
(RTM) on Windows 2008 Server Standard Service Pack 2. When I attempted
to upgrade the instance to SQL Server 2008 Enterprise Edition by running
setup.exe, the following error occurred:
The selected SQL Server instance does not meet upgrade matrix
requirements.

However, I have inspected the upgrade matrix in Books Online under
"Version and Edition Upgrades," and all seems correct. Since an MSDN
license is being used, the PIDs are the same for both editions.

I don't know if there is anything special for MSDN license, but I have
not heard of any.

But just a stupid check, you are not trying to upgrade from x86 to x64,
are you? That is not supported.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000:
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.