DataBase & Business Intelligence Expert Solution
  Home   Services Forum Jobs References Live demo   Contacts  
Mnaouar Ben Khelifa
Subscribe?     Forgot Password ?
tunis annonces femme cherche
End of Left Navigation
End of Left Navigation
End of Left Navigation
weather montreal
tunis annonces You are here: Home > Annoncevous > XMLA >

Mnaouar ben khelifa website


XMLA Setup


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 Service)


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 Sample Application.



database solution, BI solution, provide solutions to the most complex database and BI problems

Data base & business intelligence solution website