Upgrade Express 2005 SP2 to Standard Edition RRS feed

  • Question

  • Hi Guys,


    Having some problems Upgrading from SQL Express 2005 SP2 to SQL 2005 Standard. I'm getting the following:


    Name: Microsoft SQL Server 2005 Express Edition

    Reason: Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.

    Build version check:

    Your upgrade is blocked because the existing component is a later version than the version you are trying to upgrade to. To modify an existing SQL Server component, go to Add or Remove Programs in Control Panel, select the component you would like to modify, and then click Change/Remove.


    Pretty sure that I have to have SQL 2005 Std w/SP2 but I don't have a CD with it on. Is there a way that I can create one so that I can upgrade the SQL Instance In-Place.


    Thanks in advance


    Friday, December 14, 2007 5:19 AM



    There is no way to create a slipstreamed Standard which includes SP2, but you can launch your SQL Standard setup.exe with SKUUPGRADE=1 and you should be able to upgrade.


    Sam Lester (MSFT)

    Friday, December 14, 2007 5:58 AM