Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
How to configure Analysis Services for the Web

How to configure Analysis Services for the Web

SQL Server 2000

To configure Analysis Services for the Web

  1. Copy the Msolap.asp file from the C:\Program Files\Microsoft Analysis Services\Bin folder to the C:\Inetpub\Wwwroot folder of the computer that you want to use as an Analysis server. (The actual locations might differ from these default locations.) This computer must be accessible through a connection authenticated by Microsoft® Internet Information Services (IIS).

    Important  If the C:\Inetpub\Wwwroot folder does not exist on the Analysis server computer, IIS might not be installed. IIS must be installed on the Analysis server computer, and a name or IP address must be assigned to the default Web site before you can complete this procedure. The Analysis server computer must be running an operating system that supports IIS, such as Microsoft Windows NT® 4.0 Server (not Windows NT 4.0 Workstation) or Microsoft Windows® 2000.

  2. Create or open a Microsoft Management Console (MMC) console containing the Internet Information Services snap-in.

    On Windows 2000, you can open Administrative Tools and run Internet Services Manager.

  3. In the console tree, expand the server you are administering, and then click Default Web Site.

    If the server you want to administer does not appear in the console tree, right-click Internet Information Services, and then click Connect to specify the server.

  4. In the details pane, right-click Msolap.asp, and then click Properties.

  5. In the Properties dialog box, select the Read check box if it is not selected, and then select the Script source access check box. Click OK to set these properties and close the dialog box.

  6. In the tree pane of the Internet Information Services snap-in, right-click the Web site, and then click Properties.

  7. In the Web site properties dialog box, click the Home Directory tab. Depending on the operating system of the Analysis server computer, make the following changes for the site where Msolap.asp is hosted:
    • For Windows 2000, in the Execute Permissions box, select either Scripts only or Scripts and Executables. Optionally, in the Application Protection box, select High (Isolated) to ensure maximum stability for Analysis Services running as an IIS-based process.

    • For Windows NT 4.0 Server, click either Script or Execute (including script). Optionally, select the Run in separate memory space (isolated process) check box to ensure maximum stability for Analysis Services running as an IIS-based process.
  8. Click OK.

See Also

Authentication of Connections

How to register an Analysis server

© 2015 Microsoft