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

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

Comments (6)
  1. Texan says:

    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.

  2. says:

    A bit late to the party.

    SP 1 was released almost an year back & the fix was done 10 months ago.

  3. Carlos Rod says:

    I installed SQLExp2012 + SP1 on March 2013.

    Do I need this hotfix if I had to reinstall it again ?

  4. marvin hunkin says:

    hi. a blind student developer. and using a screen reader jaws for windows from htttp:// and now. tried installing sql management studio or sql server 2012. 32 bit, as i have windows 7 pro 32 bit. and now it says that the clr system types did not install. and so grabbed the msi, and installed it, and then installed the report viewer. and now it will not install. so, i cannot install and the basic management tools did not install. any hot fixes for this issue, apart from having to reinstall windows 7 with sighted help. what a nightmare, and wanted to do a sql management studio tutorial found online. and i ahve visual studio 2013 ultimate 32 bit. can you help. is there a hot fix, or how do i fix this. marvin from australia.

  5. mohammad says:

    error: could not write value to key/software

  6. Hi , i am trying installing Sql server 2012 on windows 7 sp1 64bit.
    but i am getting error like resource cant find .So can anybody suggest me how to resolve this issue. is there issue for any hw configuration
    i have i5,8gb RAM.

Comments are closed.

Skip to main content