After applying Service Pack 1 for SQL Server 2012 you may encounter a known issue! Details inside…..
Published Jan 15 2019 03:11 PM 176 Views
First published on MSDN on Jul 31, 2013
I’d like to make you aware of an issue that may occur after installing Service Pack 1 for SQL Server 2012. Some of the symptoms are:

  • The Windows Installer process (MSIExec.exe) repeatedly starts and attempts to repair specific SQL Server assemblies. Your Windows Application event log will contain entries like:

EventId: 1004

Source: MsiInstaller

Description: Detection of product '{A7037EB2-F953-4B12-B843-195F4D988DA1}', feature 'SQL_Tools_Ans', Component '{0CECE655-2A0F-4593-AF4B-EFC31D622982}' failed. The resource''does not exist.

EventId: 1001

Source: MsiInstaller

Description: Detection of product '{A7037EB2-F953-4B12-B843-195F4D988DA1}', feature 'SQL_Tools_Ans’ failed during request for component '{6E985C15-8B6D-413D-B456-4F624D9C11C2}'

  • Users are unable to log into Windows with their profile.
  • Insufficient resource errors when starting various services/applications.
  • The Windows registry has grown close to the 2 GB limit.

*If you installed Service Pack 1 through the Product Update/Slipstream method the symptoms do not occur

The good news is that the original cause of the problem has been resolved. The fix can be downloaded via the following link:

Windows Installer starts repeatedly after you install SQL Server 2012 SP1

You’ll also notice an update to the Service Pack 1 download page:

NOTE: MANDATORY SP1 Hotfix available: SP1 installations are currently experiencing an issue in certain configurations as described in Knowledge Base article KB2793634 . The article provides a fix for this issue that is currently available for download, and is MANDATORY for application immediately following a Service Pack 1 installation. The fix is also being made available on Microsoft Update.

If your symptoms are severe enough in that you’re unable to apply the patch, contact Customer Support Services and we’ll be glad to help.

Troy Moen – Support Escalation Engineer

Version history
Last update:
‎Jan 15 2019 03:11 PM
Updated by: