IIS 与 Sql Server Reporting Services 冲突
在 Visual Studio 中运行时,我的 mvc3 应用程序不要求任何身份验证。但是,当我部署到测试服务器(Windows Server 2008 和 IIS 7)时,我不断收到询问用户名和密码的提示。我提供了服务器的管理员凭据,但出现故障。奇怪的是,页面已提供,但我不断收到提示。然而,所有 ajax 调用都会失败,并出现 401 Unauthorized 错误。
我尝试了不同类型的身份验证,但结果是相同的。即使仅使用匿名身份验证,我也会收到输入用户名和密码的提示。
我尝试将管道从托管更改为经典,但 MVC 无法工作并且出现 404 错误。这是我的第一个 mvc 应用程序,我没想到在部署中会出现这样的问题。
有任何线索如何让它发挥作用吗?
==编辑开始=== 我怀疑这可能是导致问题的原因。在服务器上,该站点绑定到 test.xyz.com。此外,还安装了 Sql Server Reporting Services。我的应用程序尝试查询 url test.xyz.com/Reports 但我认为这与 SSRS 绑定。当我停止 SSRS 服务时,出现服务不可用 503 错误。否则我会得到一个身份验证窗口。
我试图找出如何删除特定的 SSRS 绑定,以便 test.xyz.com/Reports 指向我的报告控制器 ==编辑结束====
When running in Visual Studio, my mvc3 app does not ask for any authentication. However, when I deployed to test server (Windows Server 2008 and IIS 7) I keep getting a prompt asking for UserName and Password. I supply the admin credentials for the server yet there is a failure. The strange thing is that the page is served but I keep getting the prompt. All the ajax calls however fail with a 401 Unauthorized error.
I tried different types of authentication but the results are the same. Even with anonymous authentication only I get a prompt for user name and password.
I tried changing the pipeline from Managed to Classic but then MVC would not work and I get 404 error. This is my first mvc app and I did not expect such issues in deployment.
Any clues how to get this to work?
==Edit begin===
This is what I suspect might be causing the issue. On the server the site is bound to test.xyz.com. Also, there is Sql Server Reporting Services Installed. My application is tries to query the url test.xyz.com/Reports but I think this is bound to SSRS. When I stop the SSRS service I get a service unavailable 503 error. Otherwise I get a authentication window.
I am trying to find out how can I remove the particular SSRS binding so that test.xyz.com/Reports points to my Reports Controller
==Edit end====
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(3)
您还可以使用 Reporting Services 配置管理器指定 Reporting Services 在服务器上使用的端口和 URL。
默认情况下,SQL Server Reporting Services 使用以下 URL:
http://msdn.microsoft.com/en-us/library/ms159261(v=sql.105).aspx
You can also use Reporting Services Configuration Manager to specify the port and url that Reporting Services uses on the server.
By default SQL Server Reporting Services uses the following urls:
http://msdn.microsoft.com/en-us/library/ms159261(v=sql.105).aspx
要检查的事项:
启用匿名访问
?Things to check:
Enable anonymous access
?我将控制器从 Reports 更改为 MyReports,这解决了冲突。
I changed my controller from Reports to MyReports and this resolved the conflict.