Create a new folder c:\XMLA
Copy c:\Program Files\Microsoft SQL
Server\MSSQL.2\Olap\Bin\isapi folder to the new folder. Copy \Bin\xmlrwbin.dll
file to the folder too.
You may need to explicitly change the ACL for
this folder (c:\XMLA). The updated ACL should allow Read permissions for the
identity of the application pool that is loading the pump (by default, Network
Create a virtual directory “XMLA” pointing to
the location of msmdpump.dll (c:\XMLA\ isapi)
Enable "Scripts and Executables" on
the virtual directory
Setup security on the virtual directory:
Enable anonymous access only and make sure that the anonymous user has full
access to the Analysis Services.
Create a mapping from ".dll" to
msmdpump.dll in the properties of the
virtual directory (Configuration -> Application Mappings -> .dll =
msmdpump.dll). You may need to hit the
tab key several time until the OK button becomes enabled.
For Windows 2003 server, click on Web Service
Extensions, add a new extension. You must add both msmdpump.dll and
xmlrwbin.dll to the
file list. Go to Application Pools, and create a new application pool.
Right click on it and select Properties, go to Identity tab, for Predefined,
select Local System. Click OK to close.
Test the http://localhost/OLAP/msmdpump.dll
with MDX.htm file. Note that you not
test the URL typing it in the Internet Explorer as you can with XMLA SDK. You can also test the URL with XMLA SDK