Express to Standard upgrade

Question

I have SQL Server 2005 Express that was installed with SharePoint Server 2007. I'm trying to upgrade it to SQL Server 2005 Standard edition and it gives this "Edition Change Check (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."

I tried "setup skuupgrade=1" from the command prompt, but it's giving me the same message.

Can someone tell me how to correctly make the upgrade?

Sam

Answer 1

The paramater is case sensitive you need to use:

setup.exe SKUUPGRADE=1

Answer 2

Thank you. That did it!

Answer 3

Hi isunshine,

 

I am also trying to upgrade my SharePoint 2007's SQL Express (default installation) to SQL Standard 2005. Since I have lot of contents on the SharePoint 200, I just thought to reconfirm with you.  (Since you did the same thing). Did you have problems with SharePoint after the upgrade to SQL Standard 2005? Was you SQL Server express  named server?

 

Thank you,

 

KG

Answer 4

No, i didn't have a problem after the upgrade. But mine didn't have lots of content so it could be a different story... i'm not quite sure what you mean by "named server".

Answer 5

When you install SQL Server you could select whether you want it to be default server or name server (name instance). I have a default instance of SQL Server 2005 installation as such we installed the name server (or name instance of the SQL Sever)

 

Thank you                             

KG