다음을 통해 공유

MS12-027 may fail on servers with SQL 2005

  • 아티클

The MS12-027 security bulletin was just released on 4/10 which contains a fix to Office 2003 web components.  What does this have to do with SQL Server you ask?  Well, SQL Server 2005 installs the Office 2003 web components as part of the install. I believe this is part of the management tools only, but I have not been able to confirm as of yet.  The problem that has been occurring is that the installation of this security update fails with the following error:

“The expected version of the product was not found on your system”

This is because SP3 of the Office 2003 Web Components are a prerequisite for this security update which is explained in KB2597112. If your system is updated via automatic updates, then you will already have this installed and should not experience this problem.  In many large corporate environments, security updates are managed and deployed internally.  It is easy to overlook that Office 2003 Web Components need to be patched on SQL Servers. An easy way to check is to look in “Installed Updates" in control panel and confirm that sp3 has been installed for Office 2003 Web Components.  If not, that will need to be installed prior to running this security update.

SQL 2008 and R2 does not appear to be affected.  If you look in Control Panel it may appear as though you have “Office 2003 Web Components” installed, but if you look at installed updates you will notice that what you really have is the “Office 2003 Web Components for Office 2007”.  That is the component that is installed as part of the SQL 2008 and R2 installs.  This component does not appear to have the same prerequisite.  There is an SP1 for this particular component, and I would suggest installing that if you do not have it already.

I want to thank my fellow PFE Joe McT for brining this to my attention.  It goes to show that when you have access to a PFE as a customer, you get access to all PFEs!

Happy patching everyone!

Comments

  • Anonymous
    April 12, 2012
    The comment has been removed

  • Anonymous
    April 12, 2012
    The comment has been removed

  • Anonymous
    April 12, 2012
    The comment has been removed

  • Anonymous
    April 12, 2012
    The comment has been removed

  • Anonymous
    April 13, 2012
    The comment has been removed

  • Anonymous
    April 14, 2012
    Well, I clearly SHOULD have no trouble... but trouble I've got. The FixIt tool is failing instantly. I'm going to try to find the half-hour or so to go through the extensive manual process for resetting the update software. I tried it once and may have fumblefingered something (the instructions are horrible, don't fit on a page when printed, and are in a bulleted list that cannot be easily copied and pasted to a .BAT file or even the command prompt). I'm grumpy about this. But I'm hoping I'll get there without having to wipe and rebuild this machine.

  • Anonymous
    April 16, 2012
    The comment has been removed

  • Anonymous
    June 15, 2012
    The comment has been removed

  • Anonymous
    June 15, 2012
    The comment has been removed