SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


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


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

Author
Message
jam471 56572
jam471 56572
Grasshopper
Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)

Group: General Forum Members
Points: 19 Visits: 10
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
Thom A
Thom A
SSC-Forever
SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)

Group: General Forum Members
Points: 45606 Visits: 15469
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 :-P

Please always remember to encapsulate your code in IFCode Markup. For example [code=sql] [/code].
Click here to read Jeffs Guide on how to post SQL questions, and get swift and helpful answers from the community
jam471 56572
jam471 56572
Grasshopper
Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)

Group: General Forum Members
Points: 19 Visits: 10
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.
Thom A
Thom A
SSC-Forever
SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)

Group: General Forum Members
Points: 45606 Visits: 15469
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 :-P

Please always remember to encapsulate your code in IFCode Markup. For example [code=sql] [/code].
Click here to read Jeffs Guide on how to post SQL questions, and get swift and helpful answers from the community
jam471 56572
jam471 56572
Grasshopper
Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)

Group: General Forum Members
Points: 19 Visits: 10
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.

Thom A
Thom A
SSC-Forever
SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)

Group: General Forum Members
Points: 45606 Visits: 15469
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 :-P

Please always remember to encapsulate your code in IFCode Markup. For example [code=sql] [/code].
Click here to read Jeffs Guide on how to post SQL questions, and get swift and helpful answers from the community
Thom A
Thom A
SSC-Forever
SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)

Group: General Forum Members
Points: 45606 Visits: 15469
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://SRV14/reports.


Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does :-P

Please always remember to encapsulate your code in IFCode Markup. For example [code=sql] [/code].
Click here to read Jeffs Guide on how to post SQL questions, and get swift and helpful answers from the community
jam471 56572
jam471 56572
Grasshopper
Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)

Group: General Forum Members
Points: 19 Visits: 10
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.

Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum







































































































































































SQLServerCentral


Search