IIS 与 Sql Server Reporting Services 冲突

发布于 2025-01-04 22:02:16 字数 626 浏览 0 评论 0原文

在 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 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(3

岛歌少女 2025-01-11 22:02:16

您还可以使用 Reporting Services 配置管理器指定 Reporting Services 在服务器上使用的端口和 URL。

默认情况下,SQL Server Reporting Services 使用以下 URL:

http://<server name>/ReportServer // web service url

http://<server name>/reports // reports manager 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://<server name>/ReportServer // web service url

http://<server name>/reports // reports manager url

http://msdn.microsoft.com/en-us/library/ms159261(v=sql.105).aspx

深海不蓝 2025-01-11 22:02:16

要检查的事项:

  • 您的 Web 应用程序是否访问任何资源?如果是这样,IIs工作进程帐户是否有这些权限?
  • 您是否将网站身份验证设置为启用匿名访问
  • 您是否有机会进行模拟(在 web.config 中或以编程方式进行?如果是这样,最终用户帐户是否具有对任何最终后端资源的适当权限?

Things to check:

  • Does your web application accessing any resources? If so, does the IIs worker process account have permission to those?
  • Have you set the Web Site Authentication to Enable anonymous access?
  • Do you by any chance doing impersonation (either in web.config of programmatically? If so, does the end user account have the proper permissions to any eventual back end resources?
你的往事 2025-01-11 22:02:16

我将控制器从 Reports 更改为 MyReports,这解决了冲突。

I changed my controller from Reports to MyReports and this resolved the conflict.

~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文