copy: xmlA for sql analysis 2005

最新推荐文章于 2022-04-29 14:53:15 发布

转载最新推荐文章于 2022-04-29 14:53:15 发布 · 54 阅读

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/margiex/archive/2005/06/15/174782.html

博客介绍了msmdpump.dll的配置步骤。需创建指向其位置的虚拟目录，复制相关文件；在虚拟目录启用“脚本和可执行文件”并设置安全；创建“.dll”到msmdpump.dll的映射。对于Windows 2003服务器，要显式启用其为“允许”的ISAPI DLL，还可能需更改文件夹和文件的ACL。

2005 有一点不一样，不再是msisapi.dll 这个文件，而是 msmdpump.dll.
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)

转载于:https://www.cnblogs.com/margiex/archive/2005/06/15/174782.html