Jan 072013

If you are on SQL Server 2012 SP1 (11.0.3000) and are experiencing higher than normal CPU loads on your machine, please take a look at the Windows Application log for the following:

  • Warning / Event ID 1004 / MsiInstaller / Detection of product ‘{A7037EB2-F953-4B12-B843-195F4D988DA1}’, feature ‘SQL_Tools_ANS’, component ‘{0CECE655-2A0F-4593-AF4B-EFC31D622982}’ failed. The resource ” does not exist.
  • Warning / Event ID 1001 / MsiInstaller / Detection of product ‘{A7037EB2-F953-4B12-B843-195F4D988DA1}’, feature ‘SQL_Tools_ANS’ failed during request for component ‘{6E985C15-8B6D-413D-B456-4F624D9C11C2}’
  • Information / Event ID 1040 / MsiInstaller / Beginning a Windows Installer transaction: {A7037EB2-F953-4B12-B843-195F4D988DA1}. Client Process Id: 16708.
  • Information / Event ID 11724 / MsiInstaller / Product: SQL Server 2012 Management Studio — Install started.
  • Information / Event ID 10000 / RestartManager / Starting session 0 – 2013-01-07T12:40:46.549958800Z.
  • Information / Event ID 11728 / MsiInstaller / Product: SQL Server 2012 Management Studio — Configuration completed successfully.
  • Information / Event ID 1035 / MsiInstaller / Windows Installer reconfigured the product. Product Name: SQL Server 2012 Management Studio. Product Version: 11.1.3000.0. Product Language: 1033. Manufacturer: Microsoft Corporation. Reconfiguration success or error status: 0.
  • Information / Event ID 1042 / MsiInstaller / Ending a Windows Installer transaction: {A7037EB2-F953-4B12-B843-195F4D988DA1}. Client Process Id: 16708.
  • Information / Event ID 10001 / RestartManager / Ending session 0 started 2013-01-07T12:40:46.549958800Z.

If you have the above symptoms, please look at this non-security hotfix KB download: http://www.microsoft.com/en-us/download/details.aspx?id=36215. Do not install if you have already applied any post SP1 hotfixes, such as SP1 CU1. You can also view the SQL Server Connect bug here: http://connect.microsoft.com/SQLServer/feedback/details/770630.

Installing that fix will bring your SQL version to 11.0.3128, fix the problem with the MSI installer, and it should drop your CPU consumption a bit as well.

  7 Responses to “SQL Server 2012 SP1 – Endless MsiInstaller Application Log Entries”

  1. [...] SQL Server 2012 SP1 – Endless MsiInstaller Application Log Entries [...]

  2. For hottest information you have to pay a quick visit
    world wide web and on world-wide-web I found this web
    page as a most excellent web site for newest updates.

  3. Wow that was strange. I just wrote an really long comment but after I
    clicked submit my comment didn’t show up. Grrrr… well I’m not writing all that over again.
    Regardless, just wanted to say excellent blog!

  4. First off I want to ssay fantastic blog! I had a quick question that I’d like to ask
    if you do not mind. I was curious to find out how you centter yourself andd clear your thoughts before writing.
    I have had a hard time clearing my thoughts in getting my thoughts out there.I truly do
    enjoy writing howevver it just seems like the first 10 too 15 minutes arre usually wasted just trying to figure out how to
    begin. Any ideas or tips? Appreciate it!

    Feel free to visit my blog: pampers-coupons mailed to home

  5. I simply could not goo away your website before suggesting that I actually enjoyed the standard info a
    person supply to your guests? Is going to be again ceaselessly
    in order too check out nnew posts

    My website; male incontinence pads

  6. Inspiring story t?ere. ?hat occurred ?fter? ?ood luck!

    ?ere iis myy blog post – free printable powerade coupons 2011

 Leave a Reply



You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>