B.2 Microsoft SQL Server 2005

1. Microsoft Analysis Services 2005 should be installed.

2. The msmdpump.ini file in the {SQLServer}\MSSQL.1\OLAP\ bin\isapi directory is configured to use localhost by default. If the OLAP server is on another machine, the file must be reconfigured. Multiple data sources can be included in this file.

3. The msmdpump.dll file in the '{SQLServer}\MSSQL.1\OLAP\ bin\isapi' directory must be made available in a web server. Set up a virtual directory (e.g., xmla) on the web server which points to the isapi directory. When the URL (e.g., http://localhost/xmla/msmdpump.dll) is entered in a browser, it should return a SOAP message. If it fails, make sure the end user has been granted permission to execute scripts.

<< B.1 Microsoft SQL Server 2000 © 1996-2013 InetSoft Technology Corporation (v11.4) Data Mashup >>