Configure HTTP access to Analysis Services on Internet Information Services (IIS) - Example

This page provides information on how to configure HTTP access to Analysis Services with Internet Information Services (IIS) using the msmdpump.dll.

Disclaimer: This is only an example. The exact configuration depends on the specific environment.
The complete instructions on how to configure HTTP access to Analysis Services can be found at Configure HTTP Access to Analysis Services on Internet Information Services

Contents

 

General Prerequisite

The instructions on this page assume that IIS already is configured, and that Analysis Services already is installed. Windows Server 2012 for instance ships with IIS 8 as a server role that you can enable on the system. IIS 10 is shipped with Windows Server 2016.

Add/Verify MSMDPUMP Prerequisite

Verify and add the needed server roles through the Server Manager.

  1. Open the Add Roles and Features wizard.

    2. Server Roles

  2. Proceed in the Add Roles and Features wizard to the Server Roles section.
  3. Scroll down to Web Server and expand Security.
  4. Choose these authentication methods:

    5. Authentication

  5. Expand the Application Development section.
  6. Choose CGI and ISAPI Extensions.

    7. Application Development

Copy MSMDPUMP Files

  1. Create a new folder called OLAP in <drive>:\Inetpub\wwwroot
  2. Copy the msmdpump.dll, msmdpump.ini and the Resources folder from <drive>:\Program Files\Microsoft SQL Server\<instance>\OLAP\bin\isapi to the newly created folder (<drive>:\Inetpub\wwwroot\OLAP).

    3. isapi

Create an Application Pool and Virtual Directory in IIS

An Application Pool and Virtual Directory will be used to create an endpoint for the pump.

Create an application pool:

  1. Right-click Application Pools
  2. Click Add Application Pool...
  3. Create an application pool called OLAP with the .NET CLR version set to .NET CLR Version v.4.0.30319 and Managed pipeline mode set to Classic

    4. Application Pool

Convert to Application

There should now be a folder named OLAP, under the web site node.

  1. Right-click the folder and click Convert to Application

    2. Website

  2. Choose the application pool named OLAP in the Add Application dialog.
  3. Enter the physical path to the OLAP folder under wwwroot, e.g. C:\inetpub\wwwroot\OLAP
  4. Click OK

    5. Select App Pool

  5. Refresh the web site and notice the changed icon in the navigator.

    6. Virtual path

 

Configure IIS Authentication

  1. Select the virtual directory named OLAP in the web site navigator. The main window will show the OLAP home.
  2. Double-click Authentication in the OLAP home.
  3. Enable Windows Authentication using right-click on that authentication method.

    4.  Win Auth

  4. Open the OLAP home again by clicking OLAP in the web site navigator.
  5. Double-click Handler Mappings on the OLAP home.
  6. Right-click anywhere on that page and choose Add Script Map.

    7. Handler map

     

    In the Add Script Map dialog:
  7. Enter *.dll as the Request path.
  8. Enter the msdmpump.dll location, e.g. C:\inetpub\wwwroot\OLAP\msmdpump.dll, as the Executable.
  9. Enter OLAP as the Name.

    10. Add script map

  10. Click Yes when prompted to allow ISAPI extension.

 

Test the Endpoint

Test the endpoint by connecting to it from SQL Server Management Studio.

Use the endpoint URL as Server Name, e.g. http://<server>/OLAP/msmdpump.dll

SSMS