SQL 2008 SP3 Fails

Posted on 2012-09-13
Last Modified: 2012-12-04
I've tried several times (at least 6) to install the SQL 2008 SP3 but it fails every time.  I've attached a screen print of the error and the summary log file from the latest attempt.  
We're currently at SQL version 10.00.1600.22, it's SQL 2008 not SQL 2008 R2.
All the SQL services were stopped when we attempted this update.
If anyone has a work around, please let me know.
Question by:skbarnard
    LVL 28

    Expert Comment

    by:Ryan McCauley
    The log file and error you've attached really don't have much detail, and I don't see anything that sheds like on the specifics of your failure reason. Is this the first indication that your installation isn't going to upgrade, or do you get some warnings earlier in the process.

    Also, it looks like you're trying to upgrade the database engine and the shared features at the same time and they both fail. Though this is usually fine and I've always done everything at once, do you get the same failure if you only attempt one of them instead? I once saw a case, though on SQL 2005, where we could service pack one instance at a time, but not more than one (the shared features are selected separately, listed alongside the instances as though they're another one).

    Author Comment

    The shared features checkbox is grayed out so I'm unable to deselect it however, I'm attempting a run right now having deselected the MSSQLSERVER instance.
    If the shared features upgrade, I will then attempt the instance upgrade.
    I'll keep you posted.

    Author Comment

    I started the process then I went out to lunch.  The shared resources portion of the update failed too.
    I'm attaching the detail log that may help shed more light on what fails (at least for anyone that sees this thread, it's not all that helpful to me; I don't have much programming background)
    LVL 28

    Accepted Solution

    Okay - there's a pretty solid error in that log file, near the bottom:

    2012-09-13 12:18:14 Slp: Error: Action "ValidateFeatureSettings" threw an exception during execution.
    2012-09-13 12:18:14 Slp: Microsoft.SqlServer.Setup.Chainer.Workflow.ActionExecutionException: Element not found. (Exception from HRESULT: 0x80070490) ---> System.Runtime.InteropServices.COMException (0x80070490): Element not found. (Exception from HRESULT: 0x80070490)

    Any chance this applies to you?

    There's also another post where somebody refers to that Connect bug (and the work-around), but also mentions having to modify node ownership:

    I'm hopeful!

    Assisted Solution

    Sorry I've been remiss at not checking back here until now, we've had a lot of little gremlins running around so fires have had to be put out and took priority.
    Our SQL setup is clustered and we have a SAN that has volumes that are presented to the servers.
    Based on the links provided by ryanmccauley, I removed those volumes from the server ("unshared" them from the SAN), stopped all the SQL services and tried to install again (as administrator) - still no joy.
    I guess my next step would be to remove the node ownership - anyone know how I can do that?

    Author Closing Comment

    Sorry I've been so slow to respond to this question.  If you've looked through this thread you've seen that we're set up in a clustered environment.  It turns out that in addition to stopping all SQL services, we also had to stop the cluster service.  We'd neglected doing that and that interfered with the installation.

    Featured Post

    Looking for New Ways to Advertise?

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

    Join & Write a Comment

    Suggested Solutions

    There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
    Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    746 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

    13 Experts available now in Live!

    Get 1:1 Help Now