How do I upgrade my MSDE instances to SQL Server 2008

Posted on 2009-02-21
Last Modified: 2013-11-13
I have a server running Microsoft Server 2003 standard, SP2. The server hosts 4 instances of MSDE 2000. I am trying to upgrade them to SQL Server 2008. When I insert the SQL Server 2008 installation CD and follow the installation path to "Upgrade to SQL Server 2008" (as opossed to installing a standalone version of SQL Server 2008), I get to a screen asking me to "Select Features". There are two features in the window called "Shared Features" and "Redistributable Features", but they are greyed out and are therefore not selectable. When I click on "Next", I get an error message dialogue, when I close that, the error message at the bottom of the "select features" window says "there are no features selected for the upgrade", and I cannot continue (clicking "Next" loops the error message). I need to do an upgrade as I wish to retain the instance names so that I don't have to change the source of the databases in all my applications. Please help!
Question by:tafryer

    Author Comment

    I have also tried using the SQL Server 2008 Express installation, but I get the same result.
    LVL 18

    Expert Comment


    Author Comment

    I think the problem is that my MSDE instances are not patched to SP4 - they are sitting at SP3a. I just discoverd that only MSDE SP4 instances can be upgraded to SQL Server 2008. I am applying SP4 to my instances now, I will report back.

    Accepted Solution

    Hi, I have resolved the problem, it was indeed that my MSDE oinstances were at SP3a instead of at SP4. I applied SP4 to all the instances. I was then able to upgrade them. I first had to upgrade them to SQL Server 2008 express, and only them could I upgrade them to full-blown SQL 2008 standard. What a mission! But all done now, and all working fine. This question can be closed. Can I award myself the points??? :)

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now