[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


How do I upgrade my MSDE instances to SQL Server 2008

Posted on 2009-02-21
Medium Priority
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
  • 3

Author Comment

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

Expert Comment

ID: 23699571

Author Comment

ID: 23699665
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

tafryer earned 0 total points
ID: 23708777
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??? :)

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you’re making plans to join the modern business race, you should analyze various details that may affect your results. Nowadays, millions of businesses are trying to grow into established and appreciated professional enterprises.
Successful collaboration among team members is essential for the growth of your business. When employees work together on projects, share ideas and communicate effectively they get better results.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Simple Linear Regression
Suggested Courses

834 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