none
msiexec.exe processes keep running after installation of SQL Server 2012 SP1

    Question

  • Hello,

    I just installed SQL Server 2012 SP1 on top of the RTM. The installation completed without any errors and everything seemed OK until I noticed that my machine was using almost 100% constantly. When looking at the processes, I noticed 2 msiexec.exe processes which were running. Sometimes one of them disappears but half a minute later, it's back.

    When I look in the Eventlog, the following warnings are logged repeatedly:

    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}'

    I have installed SQL Server together with SharePoint 2013 RTM on the same machine and the following components have been installed:

    - Database engine
    - Management Tools (Complete)
    - Reporting Services (SharePoint Integrated mode)
    - Reporting Services Add-In for SharePoint
    - SQL Client Connectivity SDK

    I had the same issue with SP1 CTP4 on 3 completely different machines (all SharePoint 2013 machines)!! After uninstalling the SP1, the msiexec processes are gone and the CPU settles down and goes back to the normal load.

    Any pointers are appreciated...  since this SP1 adds a lot of BI features for SharePoint 2013, I really need this.

    Thanks,

    Bart


    • Edited by Bart Kuppens Friday, November 09, 2012 5:39 PM corrections in installed components
    Friday, November 09, 2012 5:35 PM

Answers

All replies

  • Hello,

    Please post about this issue on Microsoft Connect also.

    http://connect.microsoft.com/  

    Hope this helps.


    Regards,

    Alberto Morillo
    SQLCoffee.com

    Friday, November 09, 2012 5:51 PM
    Moderator
  • Would you please check-out below related thread

    http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/68d65bed-cc70-447f-b27d-7ff6840e691c


    FAQ
    ----
    Regards,
    Ahmed Ibrahim
    SQL Server Setup Team
    My Blog
    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
    This can be beneficial to other community members reading the thread.
    View Ahmed Ibrahim's profile on LinkedIn

    Sunday, November 11, 2012 12:40 AM
    Moderator
  • Thanks for the replies...

    I started over with a clean server. Nothing on it, just Windows Server 2012 Standard.
    I downloaded the image en_sql_server_2012_enterprise_edition_with_sp1_x86_x64_dvd_1174862 from MSDN.

    So, the RTM with SP1 preinstalled.

    Mounted it and installed it.

    When looking at the services, I noticed that everything was OK. No more msiexec processes running in the background. Hoorah! :)

    But then I figured... let's check the version and this is where I got a little frustrated...

    I executed the following:

    SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY('productlevel'), SERVERPROPERTY('edition')

    And this is what I got:

    11.0.2100.60   RTM    Enterprise Edition (64-Bit)

    Since I downloaded the DVD with SP1, I would have expected to see something in the likes of:

    11.0.3000   SP1   Enterprise Edition (64-Bit)

    Right?

    So... what's going on here???? Is the ISO on MSDN wrong?

    Sunday, November 11, 2012 2:14 PM
  • Could you please share the discovery report to know what exactly installed on the machine and at what level

    http://blogs.msdn.com/b/petersad/archive/2009/11/13/sql-server-2008-discovery-report.aspx


    FAQ
    ----
    Regards,
    Ahmed Ibrahim
    SQL Server Setup Team
    My Blog
    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
    This can be beneficial to other community members reading the thread.
    View Ahmed Ibrahim's profile on LinkedIn

    Sunday, November 11, 2012 8:47 PM
    Moderator
  • Same issue here.

    I have very similar clean environments (hyper-v virtual machines): Windows Server 2012 RTM + SQL Server 2012 RTM + SharePoint 2012 RTM.

    They are for test purpose only, so not much third-party software installed there.  One is built from scratch, the other one is upgraded from Windows Server 2008 R2.

    After installing SQL server 2012 sp1, the two "msiexec.exe" processes appeared in "Process Explorer".  They keep calling "ngen.exe", which called "conhost.exe".

    It seems they are trying to repair something.


    Eric Fang



    • Edited by Eric Fang Tuesday, November 13, 2012 11:00 PM
    Tuesday, November 13, 2012 10:55 PM
  • Here is my "discovery report"

    SQL Server 2012 Service Pack 1 Setup Discovery Report


    Eric Fang

    Tuesday, November 13, 2012 11:05 PM
  • Hi, I had the same issue using en_sql_server_2012_enterprise_edition_with_sp1_x86_x64_dvd_1174862 on a clean install, this was to use with SharePoint 2013. Verion showed 11.00.2100.60 and not 11.00.3000 which http://sqlserverbuilds.blogspot.co.uk/ shows it should be. This has caused issues when trying to get Reporing Services installed.

    I now see that the file i downloaded (the .iso) from MSDN has been removed and is no longer available.

    Any ideas why?

    Wednesday, November 14, 2012 2:05 PM
  • I ran that Discovery Report on my environment and here's the result:

    Product Instance Instance ID Feature Language Edition Version Clustered
    Microsoft SQL Server 2012 MSSQLSERVER MSSQL11.MSSQLSERVER Database Engine Services 1033 Enterprise Edition 11.1.3000.0 No
    Microsoft SQL Server 2012 Management Tools - Basic 1033 Enterprise Edition 11.1.3000.0 No
    Microsoft SQL Server 2012 Management Tools - Complete 1033 Enterprise Edition 11.1.3000.0 No
    Microsoft SQL Server 2012 Reporting Services - SharePoint 11.1.3000.0 No

    Wednesday, November 14, 2012 2:44 PM
  • noticed MS removed off MSDN because of an error installing SP1 on install, this explains..
    Thursday, November 15, 2012 10:53 AM
  • An update on the issue itself....

    This morning, I booted my laptop and started my VM. Left it alone for a while and then noticed that the CPU load was normal. So, I checked the processes and saw that the 2 msiexec processes were gone.

    When checking the eventlog, I noticed something... first of all, the VM booted at 8:00 AM sharp.

    The following events are logged repeatedly (on all machines I installed the SP1... the eventlog is full of these events), starting at 8:01:57 AM.

    Level Date and Time Source Event ID Task Category
    Information 15/11/2012 8:02:14 Microsoft-Windows-RestartManager 10001 None Ending session 0 started ‎2012‎-‎11‎-‎15T07:01:57.996766000Z.
    Information 15/11/2012 8:02:14 MsiInstaller 1042 None Ending a Windows Installer transaction: {A7037EB2-F953-4B12-B843-195F4D988DA1}. Client Process Id: 3492.
    Information 15/11/2012 8:02:14 MsiInstaller 1035 None 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 15/11/2012 8:02:14 MsiInstaller 11728 None Product: SQL Server 2012 Management Studio -- Configuration completed successfully.
    Information 15/11/2012 8:01:57 Microsoft-Windows-RestartManager 10000 None Starting session 0 - ‎2012‎-‎11‎-‎15T07:01:57.996766000Z.
    Information 15/11/2012 8:01:58 MsiInstaller 11724 None Product: SQL Server 2012 Management Studio -- Install started.
    Information 15/11/2012 8:01:57 MsiInstaller 1040 None Beginning a Windows Installer transaction: {A7037EB2-F953-4B12-B843-195F4D988DA1}. Client Process Id: 3492.
    Warning 15/11/2012 8:01:57 MsiInstaller 1001 None Detection of product '{A7037EB2-F953-4B12-B843-195F4D988DA1}', feature 'SQL_Tools_ANS' failed during request for component '{6E985C15-8B6D-413D-B456-4F624D9C11C2}'
    Warning 15/11/2012 8:01:57 MsiInstaller 1004 None Detection of product '{A7037EB2-F953-4B12-B843-195F4D988DA1}', feature 'SQL_Tools_ANS', component '{0CECE655-2A0F-4593-AF4B-EFC31D622982}' failed.  The resource '' does not exist.

    These events are repeatedly logged up until 9:06:42. After that... they don't occur anymore and up until now, the issue seems to be gone. I find this really weird because we have been experiencing this same issue on a server for days in a row where the eventlog is filled constantly with this sequence of events.

    Thursday, November 15, 2012 11:16 AM
  • "SQL Server 2012 with SP1 Slipstream ISO images do not install SP1" This is known issue and is documented here. please follow the workarounds mentioned.

    http://support.microsoft.com/kb/2783963

    Thursday, November 15, 2012 11:22 AM
  • Seeing the same thing here on multiple servers that were upgraded to SP1 as well as a client workstation that has only the Management Console and development tools.

    SharePoint - Nauplius Applications
    Microsoft SharePoint Server MVP - 2012

    Thursday, November 15, 2012 5:42 PM
  • Please don't mark that as a proposed answer as we're seeing this with an SP1 upgrade from RTM, not using any slipstream.  Reboot also does not resolve the issue.

    SharePoint - Nauplius Applications
    Microsoft SharePoint Server MVP - 2012

    Thursday, November 15, 2012 9:32 PM
  • Did the initial installation happens from USB drive or drive letter changed latter ?

    FAQ
    ----
    Regards,
    Ahmed Ibrahim
    SQL Server Setup Team
    My Blog
    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
    This can be beneficial to other community members reading the thread.
    View Ahmed Ibrahim's profile on LinkedIn

    Thursday, November 15, 2012 10:36 PM
    Moderator
  • No, the ISO was loaded from an existing device (D:) which has not changes since the creation of the VMs.  SP1 was run from a subfolder on C:\.

    SharePoint - Nauplius Applications
    Microsoft SharePoint Server MVP - 2012

    Thursday, November 15, 2012 10:49 PM
  • I have the same problem on a VM with Windows Server 2012 RTM and SQL Server 2012 RTM installed after applying SQL 2012 SP1.

    I have noticed that the discovery report and the versions reported in 'Programs and Features' do not completely match. Should there be component version with 11.0.2100.60?

    Installed version in Control Panel:

    Friday, November 16, 2012 4:34 PM
  • Same issue here. Fresh Windows 2012 Std server had SQL Server Standard 2012 RTM installed. Was running fine for a few weeks. Downloaded and installed SP1 installer (not ISO or slipstream), and now getting the same exact warnings as mentioned above. This happens on both servers that we have. Any updates on the issue?

    Correction: I was running SQL 2012 RTM with CU4 prior to SP1 update.  

    Friday, November 16, 2012 11:05 PM
  • Same issue also. The only way to get my CPU back is to kill the msiexec's and conhost applications in task manager.
    Friday, November 16, 2012 11:22 PM
  • As suggested by Alberto, I also posted this issue on Microsoft Connect.

    https://connect.microsoft.com/SQLServer/feedback/details/770630/msiexec-exe-processes-keep-running-after-installation-of-sql-server-2012-sp1#

    @ Ahmed : Installation was done locally => copied images to the local disk and installed from there. Binaries have never been removed or moved to another location.

    @ Ultra-Scan : Yes, the SP1 is listed as an update and is not visible in the regular programs. You need to explicitly click the "View Installed Updates" to get the SP1 package. If needed, you can uninstall it from there.

    Monday, November 19, 2012 9:05 AM
  • Hi Bart,

    Had you tried the work around in the connect item it is suggested by Steve Philip it in  the workarounds tab


    FAQ
    ----
    Regards,
    Ahmed Ibrahim
    SQL Server Setup Team
    My Blog
    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
    This can be beneficial to other community members reading the thread.
    View Ahmed Ibrahim's profile on LinkedIn

    Tuesday, November 20, 2012 1:15 AM
    Moderator
  • Ahmed, that workaround would not be an acceptable solution in our situation.  Is there a bug on this with the product team?

    SharePoint - Nauplius Applications
    Microsoft SharePoint Server MVP - 2012

    Tuesday, November 20, 2012 2:35 AM
  • Like Trevor, the suggested workaround is not an option for me. I need those management tools.
    Tuesday, November 20, 2012 7:09 AM
  • I have the same issue going on. Clean install of SQL Server SP1, SharePoint 2013 and Server 2012. The install process is killing the server and won't complete after several reboots. Need the SQL Management Tools installed on this server to manage the instance so the workaround suggested won't work for me either. Have already spent a couple of days working on this.

    UPDATE: Fixed it in my case. I killed the installer processes and launched the install for rsSharePoint.msi (the reporting services add-in). The installation for the add-in rolled back changes the stuck installation had made to SQL Mgmt Tools. I rebooted after and now Reporting Services seems to be working AND I still have SQL Mgmt. Tools. This must be one of the biggest nightmare installs I've ever seen.
    Tuesday, November 20, 2012 4:43 PM
  • Again that does not resolve our issue.  Obviously we're not dealing with Reporting Services on a server with just the SQL Database Engine + Management Tools.

    SharePoint - Nauplius Applications
    Microsoft SharePoint Server MVP - 2012

    Sunday, November 25, 2012 4:28 PM
  • Hello everyone, I've run into the same issue (sequence of event IDs but also an App crash - not sure they're related) after applying SP1 for SQL Server 2012. What was the suggested fix? and anyone experienced an App crash in your boxes? In my case it was SSAS Tabular service the one that crashed.

    I'm not sure of how you fixed the issue (or if you were able to). Can you please let me know?

    Thanks in advance!

    Monday, November 26, 2012 1:37 PM
  • Hello,

    Please see the workaround posted in the following thread. Maybe it provides a solution in the scenario you have.

    https://connect.microsoft.com/SQLServer/feedback/details/770630/msiexec-exe-processes-keep-running-after-installation-of-sql-server-2012-sp1

    Hope this helps.

    Regards,

    Alberto Morillo
    SQLCoffee.com


    Monday, November 26, 2012 1:43 PM
    Moderator
  • Uninstalling Management Studio is not a real solution, and the Reporting Services MSI did not work for my installation (I didn't have Reporting Services installed originally but gave it a shot).

    Moderators should not mark a post as a solution until MS provides a real resolution to this issue.

    Thursday, November 29, 2012 6:54 PM
  • Why is this marked as answered? I don't even have reporting services installed and I don't have SharePoint either so it's clearly not related to SharePoint alone.

    Database Engine Services
    Full-Text and Semantic Extractions for Search
    Management Tools - Basic
    Management Tools - Complete

    Uninstalling the Management Tools as suggested in the workaround here

    http://connect.microsoft.com/SQLServer/feedback/details/770630/msiexec-exe-processes-keep-running-after-installation-of-sql-server-2012-sp1

    is rediculous although clearly the issue is related to the Management Tools since on my desktop machine that only has the Managmenet Tools I'm getting the same errors. How did this make it out of Microsoft HQ and why was it pushed out on Windows Update when these problems were already documented? Serious quality control problem here, and nowhere have I seen any responses from Microsoft.

    And don't forget to go over to the connect site and Vote and tell them you can reproduce it so that perhaps someone will start paying attention.

    Thursday, November 29, 2012 8:20 PM
  • Uninstalling the Management Studio portion, and reinstalling the feature (but not re-applying SP1) appears to be a short-term workaround for this problem.

    Of course, this leaves you with unpatched tools, but is the best we can do for now, perhaps

    Friday, November 30, 2012 5:21 PM
  • Has anybody tried this: Cumulative update package 1 for SQL Server 2012 Service Pack 1

    http://support.microsoft.com/kb/2765331


    Fred

    Friday, November 30, 2012 8:28 PM
  • I can confirm that installing CU1 (http://support.microsoft.com/kb/2765331) does NOT solve this issue.

    :-/


    Oh, forgot to mention... after CU1, the version of SQL is 11.1.3321.0. So, it's definitely updated since I was on 11.1.3000 before the update.
    • Edited by Bart Kuppens Saturday, December 01, 2012 5:55 PM Added build version
    Saturday, December 01, 2012 5:51 PM
  • I too have confirmed that CU1 does not resolve this issue.
    Wednesday, December 05, 2012 3:11 PM
  • The problem is still there after installing SP1 CU1

    I am worrying that it may kill the SSD soon

    Eric Fang

    Friday, December 07, 2012 9:22 PM
  • I uninstalled all SQL features except "database engine service". That fixed the problem.

    It's OK for SharePoint.


    Eric Fang

    Saturday, December 08, 2012 12:03 AM
  • This actually doesn't work for SharePoint if you're leveraging PowerPivot.  PowerPivot requires the SSMS installation due to the need for Microsoft.AnalysisServices.Xmla binary, which is only included as part of the SSMS - Complete installation.

    SharePoint - Nauplius Applications
    Microsoft SharePoint Server MVP - 2012

    Saturday, December 08, 2012 2:57 AM
  • Microsoft posted a fix for this issue as announced in the post on Connect:

    http://connect.microsoft.com/SQLServer/feedback/details/770630/msiexec-exe-processes-keep-running-after-installation-of-sql-server-2012-sp1

    The fix can be downloaded at

    http://www.microsoft.com/en-us/download/details.aspx?id=36215

    I haven't tried it yet but comments on the same post indicate that the fix works.

    Saturday, January 05, 2013 8:59 AM
  • We have multiple servers with the Management Tools that still have the issue after applying the above patch.

    SharePoint - Nauplius Applications
    Microsoft SharePoint Server MVP
    MCITP: SharePoint Administrator 2010

    -----------------------
    This post is my own opinion and does not necessarily reflect the opinion or view of Microsoft, its employees, or other MVPs.

    Monday, January 21, 2013 4:31 PM
  • KB fix worked for me, thinx.

    Saturday, October 19, 2013 7:12 PM