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):


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.