Configure HTTP access SQL Server Analysis Server

server| Access | server

Configure the SQL Server Analysis server to be accessed via HTTP

Its HTTP access mechanism is the same as SQL2000 analysis, which enables access to the Analysis server by adding Application Mappings (ISAPI extensions) in IIS

The specific steps are as follows:
My machine Environment Win2003+iis SQL Server BETA3

1, determine the location of the SQLSERVER2005 directory where msmdpump.dll files, currently in the following directory
C:\Program Files\Microsoft SQL Server\mssql.2\olap\bin\isapi
2, create a virtual directory to point to the directory, as follows
2. 1 Create an OLAP virtual directory

2. 2 to point the virtual directory to the C:\Program Files\Microsoft SQL Server\mssql.2\olap\bin\isapi Directory

2. 3 make the virtual directory have Execute permissions

3, add the application mapping for OLAP virtual directory, convert the. dll request to Msmdpump.dll processing, as shown

Well, the configuration is basically complete, and now you can start the SQL Server Management Studio application to connect to SQL Server analysis via address Http://crserver/olap/msmdpump.dll, As shown in figure

You might wonder why Http://crserver/olap/msmdpump.dll will automatically find the SQL Server analysis instance in the machine, in fact, in C:\Program Files\Microsoft SQL The SERVER\MSSQL.2\OLAP\BIN\ISAPI directory has a configuration file called Msmdpump.ini, which is located through this configuration file, which reads as follows:
<ConfigurationSettings>
<ServerName>localhost</ServerName>
<SessionTimeout>3600</SessionTimeout>
<ConnectionPoolSize>100</ConnectionPoolSize>
</ConfigurationSettings>

In this configuration file, ServerName can also be a URL address, in addition to the machine name, machine name \ Instance name, such as <servername>http://***/***/msmdpump.dll</servername >