Registry settings for Microsoft.AnalysisServices.ChannelTransport.dll are not valid after you install the SQL Server 2008 R2 version of the MSOLAP provider on this computer

When installing PowerPivot in a multi-WFE scenario, you may need to manually register the Microsoft.AnalysisServices.ChannelTransport.dll on WFEs that do not have PowerPivot installed.

To do this, run a command prompt with an Administrator token. Navigate to (and this path may change in the future, but hopefully not):

C:\Windows\assembly\GAC_MSIL\Microsoft.AnalysisServices.ChannelTransport\10.0.0.0__89845dcd8080cc91\

Once in that directory, run:

C:\Windows\Microsoft.NET\Framework64\v2.0.50727\regasm.exe Microsoft.AnalysisServices.ChannelTransport.dll

Reanalyze the problem in Health Monitor and the issue will disappear.

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.