Error: An unexpected error has occurred: Could not load file or assembly 'Microsoft.AnalysisServices.AdomdClient, Version=9.0.242.0...

Symptom

When a user is trying to access the OLAP cubes in Excel by using Jet Reports, the following error message is displayed:

Excerpt text from the error message:

An unexpected error has occurred:  Could not load file or assembly 'Microsoft.AnalysisServices.AdomdClient, Version=9.0.242.0, Culture=neutral, PublicKeyToken89845dcd8080cc91' or one of its dependencies.  The system cannot find the file specified.

Cause

This is caused by the required ADOMD.NET client not being installed.  The client is normally installed automatically during the installation of the Jet Excel add-in but, if this error comes up, the installation was blocked and the client must be installed manually.

Resolution

Download and install the correct version of the ADOMD.NET client: ADOMD.zip.

The SQL 2005 version of the ADOMD.NET client should be installed regardless of the version of SQL that is being used at the client's organization. The Jet Excel add-in will specifically look for this version. The version of the ADOMD.NET client matching the client machine's operating system (32-bit or 64-bit) (not Microsoft Office version) should be downloaded and installed. Note that you may also need to enable the .NET Framework as described here