SQL Server 2012 PowerPivot Incorrectly Detects ADOMD.NET Causing a Failed Health Rule

When PowerPivot runs the health rule, PowerPivot: ADOMD.NET is not installed on a standalone WFE that is configured for central admin, it checks for a file version of “11.0.0.0”:

[SharePointPermission(SecurityAction.LinkDemand, ObjectModel=true)]
public override SPHealthCheckStatus Check()
{
	SPHealthCheckStatus passed;
	try
	{
		if (!HealthUtil.isCentralAdminConfiged())
		{
			passed = SPHealthCheckStatus.Passed;
		}
		else
		{
			try
			{
				if (HealthUtil.IsADOMDInstalled("11.0.0.0"))
				{
					return SPHealthCheckStatus.Passed;
				}
				passed = SPHealthCheckStatus.Failed;
			}
			catch (Exception exception)
			{
				UlsWriter.LogException(exception, UlsWriter.diagnostics.Administration);
				passed = SPHealthCheckStatus.Failed;
			}
		}
	}
	catch (Exception exception2)
	{
		UlsWriter.LogException(exception2, UlsWriter.diagnostics.Administration);
		throw;
	}
	return passed;
}

The file version is passed from this property in Microsoft.AnalysisServices.AdomdClient.AdomdConnection:

public string ClientVersion
{
	get
	{
		if (this.clientVersion == null)
		{
			FileVersionInfo versionInfo = FileVersionInfo.GetVersionInfo(Assembly.GetExecutingAssembly().Location);
			this.clientVersion = versionInfo.FileVersion;
		}
	return this.clientVersion;
	}
}

The FileVersion property of the Microsoft.AnalysisServices.AdomdClient.dll (for SQL 2012) is:

11.0.2100.60 ((SQL11_RTM).120210-1917 )

Since that doesn’t compare to “11.0.0.0”, the rule fails. This rule can be ignored for now, just make sure the proper Microsoft.AnalysisServices.AdomdClient.dll is installed at C:\Windows\assembly\GAC_MSIL\Microsoft.AnalysisServices.AdomdClient\11.0.0.0__89845dcd8080cc91\.

Trevor Seward is a Microsoft Office Apps and Services MVP who specializes in SharePoint Server administration, hybrid scenarios, and SharePoint Online. He has been working with SharePoint for 16 years from SharePoint 2003 on up, managing environments with terabytes of content for 150,000+ user organizations. Trevor is an author of Deploying SharePoint 2016 and Deploying SharePoint 2019. You can find him on Twitter and in /r/sharepoint.