Post reply

The permissions granted to user IIS APPPOOLAmazonWorld are insufficient for performing this operation

  • September 23, 2017 at 3:33 am

    #340180

    Dear All,

    I have created a webapplication where I needed to run some report. I have created my reports successfully on SSRS and now I want to run them
    in my application. But, when I created C# code and then tried to run these reports the system showed this error which states:

    Microsoft.Reporting.WebForms.ReportServerException: The permissions granted to user 'IIS APPPOOL\AmazonWorld' are insufficient for performing this operation. (rsAccessDenied) at Microsoft.Reporting.WebForms.SoapReportExecutionService.ServerReportSoapProxy.OnSoapException(SoapException e) at Microsoft.Reporting.WebForms.Internal.Soap.ReportingServices2005.Execution.RSExecutionConnection.ProxyMethodInvocation.Execute[TReturn](RSExecutionConnection connection, ProxyMethod`1 initialMethod, ProxyMethod`1 retryMethod) at Microsoft.Reporting.WebForms.SoapReportExecutionService.LoadReport(String report, String historyId) at Microsoft.Reporting.WebForms.ServerReport.EnsureExecutionSession() at Microsoft.Reporting.WebForms.ServerReport.SetParameters(IEnumerable`1 parameters) at AmazonWorld.Reports.ShowInReportViewer(String path, List`1 reportParams) in E:\SP - Projects (Web, Desktop, Graphics, Mobile)\Web Projects (C#)\Projects\AmazonWorld\AmazonWorld\Reports.aspx.cs:line 48 at AmazonWorld.Reports.Button1_OnClick(Object sender, EventArgs e) in E:\SP - Projects (Web, Desktop, Graphics, Mobile)\Web Projects (C#)\Projects\AmazonWorld\AmazonWorld\Reports.aspx.cs:line 75

    I have already tried every possible troubleshooting techniques before posting this request here. I hope to find some solution to my problem here
    on this forum.

    Your help will be appreciated.

    Thanks in advance.

    Screenshot attached below

  • September 23, 2017 at 8:17 am

    #1960617

    What is it you have tried? It sounds like the user ([IIS APPPOOL\AmazonWorld]) does not have permission to access the folder and/or report on your SSRS server. Have you given them permissions to access SSRS in the Web Portal, or added them to a AD group that does have permissions?

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • September 25, 2017 at 12:21 am

    #1960669

    Thom A - Saturday, September 23, 2017 8:17 AM

    What is it you have tried? It sounds like the user ([IIS APPPOOL\AmazonWorld]) does not have permission to access the folder and/or report on your SSRS server. Have you given them permissions to access SSRS in the Web Portal, or added them to a AD group that does have permissions?

    I cannot access localhost/reports , therefore I cannot give access to specified user. My localhost/report page is showing error page.

  • September 25, 2017 at 1:54 am

    #1960678

    jam471 56572 - Monday, September 25, 2017 12:21 AM

    Thom A - Saturday, September 23, 2017 8:17 AM

    What is it you have tried? It sounds like the user ([IIS APPPOOL\AmazonWorld]) does not have permission to access the folder and/or report on your SSRS server. Have you given them permissions to access SSRS in the Web Portal, or added them to a AD group that does have permissions?

    I cannot access localhost/reports , therefore I cannot give access to specified user. My localhost/report page is showing error page.

    If you can't access the reports either, who can? They'll need to set up the permissions.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • September 25, 2017 at 4:53 am

    #1960687

    Thom A - Monday, September 25, 2017 1:54 AM

    jam471 56572 - Monday, September 25, 2017 12:21 AM

    Thom A - Saturday, September 23, 2017 8:17 AM

    What is it you have tried? It sounds like the user ([IIS APPPOOL\AmazonWorld]) does not have permission to access the folder and/or report on your SSRS server. Have you given them permissions to access SSRS in the Web Portal, or added them to a AD group that does have permissions?

    I cannot access localhost/reports , therefore I cannot give access to specified user. My localhost/report page is showing error page.

    If you can't access the reports either, who can? They'll need to set up the permissions.

    Hahahahaha, I think you didn't understand the matter I want to share. My reports are ready, I have done the codebehind.cs, but when I try to run the reports on browser, this very error occurs. As I have mentioned a screen shoot to highlight the error.

  • September 25, 2017 at 5:03 am

    #1960691

    jam471 56572 - Monday, September 25, 2017 4:53 AM

    Hahahahaha, I think you didn't understand the matter I want to share. My reports are ready, I have done the codebehind.cs, but when I try to run the reports on browser, this very error occurs. As I have mentioned a screen shoot to highlight the error.

    No, I understood, that was what my initial post was in relation to. You then stated: "I cannot access localhost/reports , therefore I cannot give access to specified user." So, if you can't give permissions to users, then you need to speak someone who can, and ask them to give permissions to the user [IIS APPPOOL\AmazonWorld] so they they can access the reports (browser permissions should do it).

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • September 25, 2017 at 5:13 am

    #1960692

    That screenshot you've now provided is a 404 error, meaning the page you tried to access wasn't found. The address is localhost, so are you running both SSRS and your website on the same server, and is that screenshot also from that same server?

    Edit: Further to this, I suspect this is not the case, as I just noticed that the taskbar shows you are on WiFi. I would not recommend running a website or a SQL Server instance over a WiFi connection, it's asking for trouble.

    This tells me you're trying to access a webpage on another server, using the address localhost. Localhost always points to the local host (the machine you're on). You'll need to replace localhost with the name of the server that page is hosted on. For example. if your SQl Server is named "SQL14" then the webaddress http://localhost/reports should be http://SQL14/reports.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

  • September 29, 2017 at 6:00 am

    #1961592

    I have given all the required permission in Sql Server Management Studio-2014. Yet I am not having any change in the report server. I am sending herewith a screenshot of my page which I am running on Internet Explorer as an administrator. I can access the reports and can view them, but I can not access the SSRS reporting homepage. I need to access the homepage of SSRS in Internet Explorer to run my reports in my application which I have built in Visual Studio 2015.
    I hope that I am quite clear this time. 
    Thanks in advance.

  • March 30, 2018 at 10:58 am

    #1985098

    jam471 56572 - Friday, September 29, 2017 6:00 AM

    I have given all the required permission in Sql Server Management Studio-2014. Yet I am not having any change in the report server. I am sending herewith a screenshot of my page which I am running on Internet Explorer as an administrator. I can access the reports and can view them, but I can not access the SSRS reporting homepage. I need to access the homepage of SSRS in Internet Explorer to run my reports in my application which I have built in Visual Studio 2015.
    I hope that I am quite clear this time. 
    Thanks in advance.

    To be honest, I don't think you've described your situation in sufficient detail.   Thom A understands the nature of doing this kind of thing quite well, so I'm fairly confident that he knows what he's talking about.  What we're looking for from you is a more complete description of what you've done.   It sounds like you've created the reports in VS2015, but we don't know if you are deploying them only locally, or if you are deploying them to some other machine (perhaps a server), or both?.  We also don't know how, exactly, you are deploying them.   Please be much more detailed and specific about exactly what is being done.   Hate to be so anal about this kind of stuff, but when technology is involved, the details matter more than ever.   Kinda like when punctuation matters (e.g. "Let's eat, gramma" vs. "Let's eat gramma", where a mere comma makes the difference between pleasant and grossly morbid).

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply