Fix Error Server-Detection of product ‘{A7037EB2-F953-4B12-B843-195F4D988DA1}’, feature ‘SQL_Tools_ANS’ failed

Dushmantha Charaka March 06, 2025 0 Comments

Today's insights come directly from a recent server rebuild we tackled. During this process, we encountered a common, yet frustrating, SQL Server error that many system administrators face: "Detection of product ‘{A7037EB2-F953-4B12-B843-195F4D988DA1}’, feature ‘SQL_Tools_ANS’ failed."

This error, which surfaced during the SQL Server installation, halted our progress and required a deep dive into troubleshooting. It's a reminder that even routine server maintenance can throw curveballs, especially when dealing with complex software like SQL Server.

The Scenario:

We were rebuilding a server, a task that should have been relatively straightforward. However, when attempting to reinstall SQL Server, we hit a roadblock. The error message pointed to a problem with the SQL Server Analysis Services (SSAS) tools, specifically the "SQL_Tools_ANS" feature, and its associated product code.

Two (2) instances of the MSIEXEC process were running – one for our installer under the user context, and another under the SYSTEM context in the background
In addition to NGEN errors, the following error was being logged in the Event Viewer repeatedly: Detection of product ‘{A7037EB2-F953-4B12-B843-195F4D988DA1}’, feature ‘SQL_Tools_ANS’ failed during request for component ‘{6E985C15-8B6D-413D-B456-4F624D9C11C2}

The hunt started for the infrastructure team who had originally built the server and installed SQL Server. Although they did find the CPU spiking to 100% occasionally during the post-install configuration, none of them could recall anything unusual during the installation.

The Resolution

After a couple of hours of troubleshooting (and lots of coffee), we came across an MS Connect item (#770630) that propelled us towards the solution to our problem. It appears that this was an issue with the original SQL Server 2012 SP1 package. According to the related KB2793634, “This issue occurs because the SQL Server 2012 components reference mismatched assemblies. This behavior causes native image generation to fail repeatedly on certain assemblies. Therefore, a repair operation is initiated on the installer package.”

The resolution to this issue is:

If you already have SQL 2012 SP1 installed, deploy the Cumulative Update CU2 for SQL 2012 SP1 (KB2790947) OR
If you downloaded SP1 through MSDN/TechNet, the source ISO has now been fixed. Hence, download the SQL Server 2012 SP1 ISO again and re-install the product

Reference:

MS Connect #770630 [msiexec.exe processes keep running after installation of SQL Server 2012 SP1]: Link
KB2793634 [Windows Installer starts repeatedly after you install SQL Server 2012 SP1]: Link
KB2790947 [Cumulative Update 2 for SQL 2012 Service Pack 1]: Link