访问报表服务器的 AppPool 权限问题 [英] AppPool Permission Issue with Accessing Report Server

问题描述

我有一个在 Windows 7 机器上运行的 SQL Server 2008 R2 报表服务器以及一个 ASP.NET 应用程序.ASP.NET 应用程序向报表服务器发出请求，以显示报表列表、呈现报表等.我的 ASP.NET 应用程序成功获取了报表列表，但是当它尝试呈现报表时出现以下错误:

I have a SQL Server 2008 R2 Report Server running on a Windows 7 machine as well as an ASP.NET application. The ASP.NET application makes requests to the Report Server to display a list of reports, render reports, etc. My ASP.NET application successfully gets the list of reports but when it tries to render a report I get the following error:

The permissions granted to user 'IIS APPPOOLDefaultAppPool' are insufficient for performing this operation. (rsAccessDenied)

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: Microsoft.Reporting.WebForms.ReportServerException: The permissions granted to user 'IIS APPPOOLDefaultAppPool' are insufficient for performing this operation. (rsAccessDenied)

Source Error: 

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace: 

[ReportServerException: The permissions granted to user 'IIS APPPOOLDefaultAppPool' are insufficient for performing this operation. (rsAccessDenied)]
Microsoft.Reporting.WebForms.ServerReportSoapProxy.OnSoapException(SoapException e) +89
Microsoft.Reporting.WebForms.Internal.Soap.ReportingServices2005.Execution.ProxyMethodInvocation.Execute(RSExecutionConnection connection, ProxyMethod`1 initialMethod, ProxyMethod`1 retryMethod) +404
Microsoft.Reporting.WebForms.Internal.Soap.ReportingServices2005.Execution.RSExecutionConnection.LoadReport(String Report, String HistoryID) +180
Microsoft.Reporting.WebForms.ServerReport.EnsureExecutionSession() +79
Microsoft.Reporting.WebForms.ServerReport.GetParameters() +54

注意:这个相同的代码库在运行 Windows 7 和 Windows Server 2008 的多台机器上运行良好.我已经尝试了基于网络搜索的许多不同的东西，但还没有找到解决方案.对此的任何见解将不胜感激.

Note: This same code base has worked fine on multiple machines running Windows 7 and Windows Server 2008. Iv'e been trying many different things based on web searches but haven't found a solution. Any insight into this would be greatly appreciated.

推荐答案

终于搞清楚了.我的 Reporting Services 配置为本地帐户，而我的 IIS 应用程序池配置为 ApplicationPoolIdentity.我将我的应用程序池更改为 LocalSystem 并修复了它.希望这些信息对其他人有用，因为我浪费了几个小时来弄清楚这一点.

Finally figure it out. My Reporting Services were configured to a local account while my Application Pool for IIS was configured to ApplicationPoolIdentity. I changed my Application Pool to LocalSystem and it fixed it. Hopefully this information will be useful to others as I wasted several hours figuring this out.

这篇关于访问报表服务器的 AppPool 权限问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！