无法通过 IIS 7 对 Windows Server 2008 上的 SQL Server Analysis services 2008 进行 HTTP 访问
我的目的是在没有 Windows 身份验证的情况下访问 SSAS 数据库。域外的用户应该能够访问多维数据集并围绕它构建数据透视表。于是我发现我们可以使用HTTP访问来达到这个目的。
我按照以下链接 http://msdn.microsoft 中提到的每个步骤进行操作
。 com/en-us/library/gg492140.aspx
当我尝试在 Mgmt Studio 中点击 URL 时 -->分析服务
http://localhost/olap/msmdpump.dll。我收到“连接超时”和“404 错误”消息
我前往 MSDN 论坛解决同样的问题，但没有具体结果。
如何测试我的 SSAS 2008 是否可以通过 HTTP 访问进行访问。
请帮忙！！
My intention is to access the SSAS Database without Windows authentication. The user outside the domain should be able to access the cube and built PIVOT tables around it. Thus I found that we can use HTTP access for this purpose.
I followed each and every step mentioned on the following links
http://msdn.microsoft.com/en-us/library/gg492140.aspx
When I try to hit the URL in Mgmt Studio --> Analysis Services
http://localhost/olap/msmdpump.dll. I am getting the "Connection time out" and "404 error"
I went to MSDN forums for the same problem but no concrete results.
How do I test whether my SSAS 2008 is accessible with HTTP access.
Please help!!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
我对你的问题没有太多的内容，但如果我不得不猜测，我会说你可能没有在应用程序池设置中从集成切换到经典，这使得你的处理程序映射被禁用，从而给你带来了 404。
我会在您的本地开发计算机上从简单开始，然后按照允许匿名访问该站点的说明进行操作。确保您的站点使用可以访问分析服务中的多维数据集的应用程序池。此外，您不能使用 IIS 中的集成管道，您必须使用经典管道。在 IIS 中创建脚本映射（在处理程序映射下）时，请确保仔细遵循以下 URL 中的说明：
http://msdn.microsoft.com/en-us/library/gg492140.aspx
我只是按照说明操作，它对我有用。
I don't have a lot to go on from your question, but if I had to guess I'd say you probably didn't switch from integrated to classic in the application pool settings which left your handler mapping disabled giving you the 404.
I would start simple on your local development machine and follow the instructions allowing anonymous access to the site. Make sure that your site uses an application pool that has access to the cube in analysis services. Additionally, you cannot use the integrated pipeline in IIS, you will hve to use classic. When you create your script mapping (under Handler Mappings) in IIS, make sure that you follow the directions carefully from the following URL:
http://msdn.microsoft.com/en-us/library/gg492140.aspx
I just followed the instructions and it worked for me.
打开匿名身份验证将有助于授予对站点的访问权限，但我建议您至少使用基本 HTTP 身份验证甚至 Windows 身份验证。请注意，如果您使用远程 SSAS 实例（不在同一主机上），则需要双跳身份验证。为此，您必须注册 SPN 并启用 Kerberos 身份验证。
您可以通过下面提到的链接了解如何做到这一点
Microsoft - 配置对 SSAS 的 HTTP 访问
您好，
雷莫
Switching on Anonymous authentication will work to grant access to the site, however I would suggest you use at least Basic HTTP authentication or even Windows Authentication. Just note, if you're using a remote SSAS instance (not on the same host), a double-hop authentication is required. For that, you will have to register SPNs and enable Kerberos authentication.
You find out how to do that by following the links referred to under
Microsoft - Configure HTTP Access to SSAS
Greetings,
Remo