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:

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

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.