After applying Service Pack 1 for SQL Server 2012 you may encounter a known issue! Details inside…..

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 https://support.microsoft.com/kb/2793634/en-us

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

https://www.microsoft.com/en-us/download/details.aspx?id=35575

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

Comments

• Anonymous
  October 09, 2013
  A day late and dollar short. "Troy Moen – Support Escalation Engineer" - The presumed fix for this issue was released over 8-9 months back. I ran into this issue at that time and did work with 5 different teams at Customer support who asked me to rebuild the cluster. Are you suggesting that MS finally found a fix which allows to shrink the user hive even though its above 2 gigs? Do a quick chk on the net and you will find there are tons of DBAs who ran into this. So why don't you share the solution and do some good to the community.

• Anonymous
  November 01, 2013
  A bit late to the party. SP 1 was released almost an year back & the fix was done 10 months ago.

• Anonymous
  November 29, 2013
  I installed SQLExp2012 + SP1 on March 2013. Do I need this hotfix if I had to reinstall it again ?

• Anonymous
  May 25, 2014
  The comment has been removed

• Anonymous
  October 29, 2014
  error: could not write value to key/software

• Anonymous
  February 22, 2016
  The comment has been removed