updating SQL Server Express 2005 SP2 to SP3

Posted on 2009-12-31
Last Modified: 2012-05-08
I have a quick question about updating SQL Server 2005 Express SP2 to SP3.

Can I update to SP3 just by installing SQL Server 2005 Express SP3 on top of the current installation? I want to download and install this version:

The current installation is running a couple of SQL instances. I want to make sure that the update will be smooth and no reconfiguration needed.

On the other hand - SQL updates for some reason are not detected by Windows Update. Is there any way to change it? I did not register with MS when I downloaded SQL Express (happy to do it now if that could help).

Thanks for your help!
Question by:itorana
    LVL 75

    Assisted Solution

    by:Anthony Perkins
    >>Can I update to SP3 just by installing SQL Server 2005 Express SP3 on top of the current installation?<<
    Yes, you can update to SP3 by downloading and installing Service Pack 3.

    >>On the other hand - SQL updates for some reason are not detected by Windows Update. <<
    That is correct and the way it should be.

    >>Is there any way to change it?<<
    I hope not.

    Author Comment

    Great, thank you for your answer.

    I am not sure about Windows Update - here's info from MS website:

    "Important notes for using Microsoft Update
    When you use Microsoft Update to install SQL Server 2005 SP3, the installation is unattended unless components are clustered. If components are clustered, you must follow the prompts to complete the installation.
    Microsoft Update upgrades all instances of SQL Server 2005 to SQL Server 2005 SP3. For example, if you have two instances of SQL Server 2005 that are running on the computer, both instances are upgraded to SQL Server 2005 SP3.
    The SQL Server 2005 Express Edition updates are shown when you do an express scan and are available as an automatic update. The other editions of SQL Server are available as a custom update or as an optional update."

    I am not sure, but I understand that this means Windows Update should include SQL Server 2005 Express updates. What do you think?

    LVL 13

    Accepted Solution

    itorana, you are right reg the updates. Please find the below link to check if it helps:

    Author Closing Comment

    Thank you geek_vj - that was exactly it!
    You just made it whole easier!

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Join & Write a Comment

    Performance is the key factor for any successful data integration project, knowing the type of transformation that you’re using is the first step on optimizing the SSIS flow performance, by utilizing the correct transformation or the design alternat…
    Introduced in Microsoft SQL Server 2005, the Copy Database Wizard ( is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
    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.
    Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

    732 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

    19 Experts available now in Live!

    Get 1:1 Help Now