Configuring HTTP Access to SQL Server 2005 Analysis Services on Microsoft Windows Server 2003-SSAS

Configuring HTTP Access to SQL Server 2005 Analysis Services on Microsoft Windows Server 2003

Written by Edward Melomed

Monday, 21 May 2007 19:47

This paper is intended for anyone who is interested in providing access to SQL Server 2005 Analysis Services through HTTP protocol.The paper explains the steps required to set up HTTP access and discusses different performance and security settings.All the instructions in this paper are specific to the Microsoft Windows® Server™ 2003 operating system.

Overview

Microsoft® SQL Server™ 2005 Analysis Services uses the same architecture for providing HTTP access as did SQL Server 2000 Analysis Services.
The pump component is loaded into IIS (Internet Information Services) and serves as an ISAPI extension, pumping data from the client to an Analysis Services server and back.
This white paper walks you through the process of setting up HTTP access to Analysis Services when using Microsoft Windows Server™ 2003 SP1.