Install ADOMD.NET on Web Front-End Servers Running Central Administration

If you install PowerPivot for SharePoint into a farm that has the topology of Central Administration, without Excel Services or PowerPivot for SharePoint, you must download and install the Microsoft ADOMD.NET client library if you want full access to the built-in reports in the PowerPivot management dashboard. Some reports in the dashboard use ADOMD.NET to access internal data that provides reporting data on PowerPivot query processing and server health in the farm.

Applies to: SharePoint 2010

For SharePoint 2013, the provider is included in the SQL Server feature pack. For information on how to download spPowerPivot.msi, see Microsoft SQL Server 2012 SP1 Feature Pack

Download and install the client library

  1. On the SQL Server 2012 SP1 Feature Pack page.

  2. Expand the Install Instructions and find “ADOMD.NET”.

  3. Download the x64 Package of the SQL_AS_ADOMD.msi installation program.

  4. Run the .msi to install the library.

  5. Reset IIS after installation is finished. To do this, open an administrative command prompt and type IISRESET.

Verify installation

  1. Go to c:\Windows\Assembly.

  2. Right-click Microsoft.AnalysisServices.AdomdClient and select Properties.

  3. Click Version.

  4. Verify the version includes 11.0.<build number> and that the description is Microsoft.AnalysisService.AdomdClient.

See Also


PowerPivot Management Dashboard and Usage Data