MS SQL Server 2008 Service Pack 2 (KB2285068) Error Code 84C40007

Anonymous
2010-11-23T19:55:18+00:00

I've been trying to install this update via Windows Update, however, every time it begins the installation, it gives me this Error Code 84C40007. When I check the update history, it shows this update has "Failed" to install.

I haven't done anything beyond this, however, I have downloaded the same update from the MS site and am thinking of just installing it manually. However, I'd like to find out why it keeps failing to install through Windows Update and what this error code means?

I've never had problems installing Windows updates before so am not sure why this suddenly came up. I would appreciate any help.

Just to add, I did install one other update (KB2447568) at the same time through Windows Update and everything went smoothly. That update installed with no problems at all.

My specs:

Operating System: Win 7 Professional

System Type: 32 bits

Anti-virus: Microsoft Security Essentials (the most current virus and spyware definitions)

Windows for home | Previous Windows versions | Windows update

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
Anonymous
2010-11-23T22:35:17+00:00

You need Microsoft .NET Framework 4: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=9cfb2d51-5ff4-4491-b0e5-b386f32c0992&displaylang=en

I had gotten the same error so I downloaded the full install from http://www.microsoft.com/downloads/en/details.aspx?FamilyID=8fbfc1de-d25e-4790-88b5-7dda1f1d4e17.  When I tried to install the Service Pack I recieved an error asking for .NET Framework 4.  I installed the framework and re-ran windows update, everything installed fine.  Didn't even use the full service pack install.

Was this answer helpful?

2 people found this answer helpful.
0 comments

55 additional answers

Sort by: Newest
Most helpful Newest Oldest
  1. Anonymous
    2010-11-30T20:57:33+00:00

    If you encounter this problem, please submit the issue to https://connect.microsoft.com/SQLServer/Feedback?wa=wsignin1.0. We would like to investigate this issue further and understand what is causing the issue.

    When you submit, please include the SqlSetup.log that will be located at %temp% or C:\Users\Administrator\AppData\Local\Temp.

    Once you submit, please post to the forums you are submitted, so I can look for the log file.

    Thanks,

    Peter Saddow [Microsoft -- SQL Server Development Team]

    This posting is provided "AS IS" with no warranties, and confers no rights.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2010-11-30T15:52:19+00:00

    Thank you for this quick fix, Shane. Worked right away. As usual, Microsoft's non-answers were getting me nowhere, and your post did. I won't ask how you found out - downloaded everything available on Microsoft's Website; consulted a Ouija Board; lit a candle - I'm just happy I can eagerly await the next obtuse error reference from the Mothership ;o)

    Was this answer helpful?

    0 comments
  3. Anonymous
    2010-11-29T21:53:40+00:00

    SQL Server 2008 all editions except for Express core requires .NET 3.5 SP1 (http://www.microsoft.com/downloads/en/details.aspx?familyid=AB99342F-5D1A-413D-8319-81DA479AB0D7&displaylang=en). This might be an issue in the .NET check for SP2 that allows .NET 4.0 to unblock Setup. You should install .NET 3.5 SP1 before installed SQL Server SP2.

    You can determine the editions you have installed by running the SQL Server discovery report that is shown athttp://blogs.msdn.com/b/petersad/archive/2009/11/13/sql-server-2008-discovery-report.aspx

    If you are running Express Edition, then you can install .NET 4.0.

    Thanks,

    Peter Saddow [Microsoft]

    This posting is provided "AS IS" with no warranties, and confers no rights.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2010-11-29T21:17:49+00:00

    Thanks for the update and solution. I believe that everyone in this forum should be aware that in order to successfully install SQL Server 2008 SP2, you need to download the EXTENDED version of Dot Net 4.0. The key here is that this extended version provided for in the link you supplied above contains additional code need for the proper installation SQL Server 2008 SP2. This installation of Dot Net 4 augments the current install, so there is NO NEED to uninstall your current version of Dot NET 4 you already have installed.  THIS WORKS!!!!!

    Was this answer helpful?

    0 comments