Thursday, November 20, 2014

SQL Server 2012: Detection of product..., feature SQL_Tools_ANS failed during request for component

Problem

You manage a SharePoint 2013 farm having a single SQL Server 2012 instance.   You see the following warnings appear in the SQL Server application log:  
 
Log Name:      Application
Source:        MsiInstaller
Date:          [Date/Time]
Event ID:      1001
Task Category: None
Level:         Warning
Keywords:      Classic
User:          SYSTEM
Computer:      [SQL Server 2012]
Description:
Detection of product '{A7037EB2-F953-4B12-B843-195F4D988DA1}', feature 
'SQL_Tools_ANS' failed during request for component 
'{6E985C15-8B6D-413D-B456-4F624D9C11C2}'

Log Name:      Application
Source:        MsiInstaller
Date:          [Date/Time]
Event ID:      1004
Task Category: None
Level:         Warning
Keywords:      Classic
User:          SYSTEM
Computer:      [SQL Server 2012]
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.

This warning does not appear to be associated with any observable adverse impact to the farm or its capabilities.

Solution
  1. As of the date of this posting, install SQL Server 2012 SP2. 
    This service pack is a servicing-only release.  It is also a rollup of all CUs that have been published in SP1 through SP1 CU9 and thus includes the hotfix previously published that fixes this specific problem.
References
 Notes
  • UPDATE 2/3/15: issue has not appeared to date.  Confirming resolution through installation of SP2.

No comments: