How to: Install the Analysis Services OLE DB Provider on an Excel Services Computer

The Microsoft OLE DB Provider for Analysis Services (msolap100.dll) is an interface that client applications use to interact with Microsoft Analysis Services data. If you have a client or server application that connects to PowerPivot data, you might need to install the SQL Server 2008 R2 version of the Analysis Services OLE DB provider if it is missing from your system.

The most common SharePoint scenario for installing the provider is when you have a server in a SharePoint farm that runs Excel Services, but not PowerPivot for SharePoint. In this case, the application server that runs Excel Services must be manually updated to use the SQL Server 2008 R2 version of the MSOLAP100.dll that is required for PowerPivot data connections. This version of the OLE DB provider includes new transports and connection support for Analysis Services data structures that are stored in memory. PowerPivot workbooks use this provider to request query processing from PowerPivot servers in the farm.

To get the updated version, you can download and install it through the SQL Server 2008 R2 Feature Pack page.

Important

If you installed PowerPivot for SharePoint and Excel Services on the same application server in the farm, the correct OLE DB provider is already installed. You do not need to perform the steps described in this topic.

Download and install the client library

  1. On the SQL Server 2008 R2 Feature Pack page, find Microsoft Analysis Services OLE DB Provider for SQL Server 2008 R2.

  2. Download the x64 Package of the SQLServer2008_ASOLEDB10.msi installation program.

  3. Double-click the .msi to install the data provider.

  4. Repeat the previous steps on each computer that has Excel Services, but no PowerPivot for SharePoint installation.

Verify installation

  1. Go to Program files\Microsoft Analysis Services\AS OLEDB\10.

  2. Right-click msolap100.dll and select Properties.

  3. Click Details.

  4. View the file version information. The version should include 10.50.<buildnumber>.