What is the best way to use teh SKUUPGRADE parameter when upgrading SQL from express to standard.

I am trying to upgrade SQL 2005 Express to SQL 2005 standard.

During the system configuration check all the checks return a green check mark except the last one.

It has this warning message  

"* To change an existing instance of Microsoft SQL Server 2005 to a different edition of SQL Server 2005, you must run SQL Server 2005 Setup from the command prompt and include the SKUUPGRADE=1 parameter."

What is the best way to do this and what is the correct command line use of this parameter?
baddoggreblutsAsked:
Who is Participating?
 
imitchieCommented:
Just run this

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

!!!BUT PLEASE NOTE!!!
SKUUPGRADE will remove all hotfix and service pack updates from the SQL Server instance being upgraded. Once the edition upgrade is complete, you must reapply all hotfix and service pack updates.
0
 
baddoggreblutsAuthor Commented:
The command line was working like a charm then failed on the database engine and threw this error.

"TITLE: Microsoft SQL Server 2005 Setup
------------------------------

SQL Server Setup cannot perform the upgrade because the component is not installed on the computer. To proceed, verify that the component to be upgraded is currently installed, and that the component to be upgraded is specified in the ADDLOCAL property. For more information, see Running Setup from the Command Prompt in SQL Server Books Online.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=setup.rll&EvtID=28011&EvtType=sqlca%5cupgradesql.cpp%40FindUpgradeableProduct%40sqls%3a%3aUpgradeSql%3a%3agetUpgradeProduct%40x6d6b

------------------------------
BUTTONS:

OK
------------------------------

What now? The link took me nowhere.

0
 
imitchieCommented:
Does your SQL 2005 Express have an instance name?
go to control Panels, Administrative Tools, run Services
go down to SQL Server, does it have a name in brackets,i.e.

SQL Server (MyInstance) ?

If it does,

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

Match MyInstance in the command above with the instance name
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
baddoggreblutsAuthor Commented:
Getting closer.

Replacing the myinstance name furthered the process.

I now get a message the the product key does not match and to re-enter the key. Is there a place in the command line to enter a key or make a reference to a text or ini file with the key?
0
 
YveauCommented:
If you want to go that path, check out:
http://msdn2.microsoft.com/en-us/library/ms144259.aspx

... if I were in your shoes ... make sure you have a good set of backups, uninstall the express edition and do a clean install of the standard edition !

Hope this helps ...
0
 
imitchieCommented:
Yveau gave the link
0
 
baddoggreblutsAuthor Commented:
I'm still getting the error below. Any thoughts.

TITLE: Microsoft SQL Server 2005 Setup
------------------------------

The SQL Server product key is not valid. To proceed, re-enter the product key values from the SQL Server installation CD sleeve.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=setup.rll&EvtID=28021&EvtType=sqlca%5csqlcax.cpp%40DetectProductID%40DetectProductID%40x6d75

------------------------------
BUTTONS:

OK
------------------------------
0
 
imitchieCommented:
What the error says: Your key is invalid. Probably time to check with where you got it.
0
 
YveauCommented:
It's is a known issue ... upgrading SQL Server 2005 ...
Even Microsoft advises to uninstall any previous SQL 2005 software after backing all databases up and install from scratch. After that a restore and you're back in business within half a day ... look what time it takes you to figure this all out ... Please do reconsider if you want to do in in place upgrade ...

Hope this helps ...
0
 
baddoggreblutsAuthor Commented:
Thanks Yevau,

I found this and with some fine tweaking of the the command line I got the silent upgrade to work. My last issue was entering the PIDKEY for the upgrade.

d:\admin\sql2005setup\setup.exe ADDLOCAL=SQL_Engine PIDKEY=Your Key INSTANCENAME=SQLEXPRESS UPGRADE=SQL_Engine SKUUPGRADE=1 /qb

I copied the install files to my hard drive. If you use the cd you need to add this to the command line to allow for the cd to start up.

Thanks for the help everyone but i solved this one myself.

I used this as my template and did a full upgrade not just the reporting server.
See: http://technet.microsoft.com/en-us/library/ms403393.aspx

This document also outlines applying service packs and special steps required.

Another minor issue of this is the instance name of the server remains SQLEXPRESS.

0
 
YveauCommented:
Don't forget to get the refund ...
http://www.experts-exchange.com/help.jsp#hi70
0
 
baddoggreblutsAuthor Commented:
I found this and with some fine tweaking of the the command line I got the silent upgrade to work. My last issue was entering the PIDKEY for the upgrade.

d:\admin\sql2005setup\setup.exe ADDLOCAL=SQL_Engine PIDKEY=Your Key INSTANCENAME=SQLEXPRESS UPGRADE=SQL_Engine SKUUPGRADE=1 /qb

I copied the install files to my hard drive. If you use the cd you need to add this to the command line to allow for the cd to start up.

Thanks for the help everyone but i solved this one myself.

I used this as my template and did a full upgrade not just the reporting server.
See: http://technet.microsoft.com/en-us/library/ms403393.aspx

This document also outlines applying service packs and special steps required.

Another minor issue of this is the instance name of the server remains SQLEXPRESS
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.