copy: xmlA for sql analysis 2005
2005 有一点不一样,不再是msisapi.dll 这个文件,而是 msmdpump.dll.
google 了半天,这个网站给了一个比较详细的定位endpoint 的方法
http://www.mosha.com/msolap/faq.htm
google 了半天,这个网站给了一个比较详细的定位endpoint 的方法
http://www.mosha.com/msolap/faq.htm
- Create a virtual directory pointing to the location of msmdpump.dll. Note that if you wish to copy this dll into a new location, you will also need to copy resources folder, since it depends on the resource files. Also copy xmlrw.dll and xmlrwbin.dll into the same directory.
- Enable "Scripts and Executables" on the virtual directory
- Set up security on the virtual directory
- Create a mapping from ".dll" to msmdpump.dll in the properties of the virtual directory (Configuration -> Application Mappings -> .dll = msmdpump.dll). This will allow clients to specify URL only in the Data Source property, and not to combine it with /msmdpump.dll suffix.
- For Windows 2003 server, you may need to explicitly enable the msmdpump.dll as an "Allowed" ISAPI DLL.
- You may need to explicitly change the ACL for this folder: c:\Program Files\Microsoft SQL Server\MSSQL.1\OLAP\Bin\isapi and for the msmdpump.dll file inside the folder. The updated ACL should allow Read permissions for the identity of the application pool that is loading the pump (by default, Network Service)