Express to Standard upgrade

Hot Topic

Permissions
Preserving SQL DB when applying application update
Rendering HTML in text box
Make a validate rule in a table
Schedule SQL Express BAckup using SQL DMO
SQL Server agent
Show dimension members only if there is data associated with them
Need help installing SQL Server 2005 Compact Edition.
SQL Select
Level function with multiple hierarchies

SQL Server

accessing report
how to write this trigger
Data Transformation Project Template for SQL 2005
Row yielded no match during lookup
Merge Join vs. Lookup vs. Custom Script - which is fastest?
My SQL is not working!!! My Hair is gone is the topic - FK creation not being called and more
SP1 Integration Services update package fails
CREATE TABLE scripts
Using expressions in other expressions in SSRS 2000
Are these queries possible without cursors or a while loop?

Express to Standard upgrade

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 this question

Express to Standard upgrade

  • Nelson Rodrigues

    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

  • Foolios

    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

  • iamme

    The paramater is case sensitive you need to use:

    setup.exe SKUUPGRADE=1



  • joeydj

    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".

  • Ying06

    Thank you. That did it!
  • Express to Standard upgrade
Answer this question