question

DavidChase-4918 avatar image
0 Votes"
DavidChase-4918 asked Joyzhao-MSFT edited

APPPOOL error running SSRS

We are trying to run SSRS report from a new website and we are getting the error details below. Where do I go to allow correct permissions?

Process information:
Process ID: 18780
Process name: w3wp.exe
Account name: IIS APPPOOL.NET v4.5


Exception information:
Exception type: SoapException
Exception message: System.Web.Services.Protocols.SoapException: The permissions granted to user 'IIS APPPOOL.NET v4.5' are insufficient for performing this operation. ---> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'IIS APPPOOL.NET v4.5' are insufficient for performing this operation.
at Microsoft.ReportingServices.Library.ReportExecution2005Impl.LoadReport(String Report, String HistoryID, ExecutionInfo3& executionInfo)
at Microsoft.ReportingServices.WebServer.ReportExecutionService.LoadReport(String Report, String HistoryID, ExecutionInfo& executionInfo)
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at Microsoft.Reporting.WebForms.Internal.Soap.ReportingServices2005.Execution.ReportExecutionService.LoadReport(String Report, String HistoryID)
at FilesClass.CreatePDFReport(String strReportName, Int32 intRecordID, Int16 intType) in E:\shared\apps\RepairTrak\App_Code\FilesClass.vb:line 364
at orders_FinalBillReports.Page_Load(Object sender, EventArgs e) in E:\shared\apps\RepairTrak\Repairs\FinalBillReports.aspx.vb:line 67
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

sql-server-reporting-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered Joyzhao-MSFT edited

Hi @DavidChase-4918 ,
If you haven’t change the Identity account for your application, then when running the report in the application, it will use the default Identity account “ApplicationPoolIdentity” to access to report server. The default do not have the permission to access report server.Please check to change the Identity user account in the Process Model to the one have the right permission. If your Reporting Services is configured as a local account, try changing the application pool to LocalSystem.
You can follow steps below to configure the Identity:

  • Go to Run (Win+R Shortcut) and then type “inetmgr” and hit “OK” button.

  • Now you are in the IIS and now expand left pane and click on the “Application Pools”

  • Then in the right hand Actions sidebar, click Add Application Pool... and then in the pop-up box Name your AppPool, select the .NET Framework version and Managed pipeline mode, then click OK.(If you have already created the pool, you can just select that pool to continue the configure)

  • Now right-click on the Application Pool you just created, and click on “Advance Settings”.

  • Now open “Advance Settings” window and scroll down window to “Process Model”. Under the “Process Model” section select “Identity” property.

  • Select an account other than “ApplicationPoolIdentity” which have the right permission to the Report Server.
    For more information,please refer to: How to Fix SSRS IIS7 permissions granted are insufficient Error.
    AppPool Permission Issue with Accessing Report Server.
    Login failed for user iis apppool default apppool System.Data.Sqlclient.Sqlexception.
    Hope this helps.
    Best Regards,
    Joy


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered

the permissions granted to user 'IIS APPPOOL.NET v4.5' are insufficient for performing this operation

A clear message, you have to grant access permissions for the service account or you have to delegate an other account in IIS which have the required permissions.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.