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
Valued Member
Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)

Group: General Forum Members
Points: 73 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 Guru
SSC Guru (70K reputation)SSC Guru (70K reputation)SSC Guru (70K reputation)SSC Guru (70K reputation)SSC Guru (70K reputation)SSC Guru (70K reputation)SSC Guru (70K reputation)SSC Guru (70K reputation)

Group: General Forum Members
Points: 70827 Visits: 18528
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
Valued Member
Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)

Group: General Forum Members
Points: 73 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 Guru
SSC Guru (70K reputation)SSC Guru (70K reputation)SSC Guru (70K reputation)SSC Guru (70K reputation)SSC Guru (70K reputation)SSC Guru (70K reputation)SSC Guru (70K reputation)SSC Guru (70K reputation)

Group: General Forum Members
Points: 70827 Visits: 18528
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
Valued Member
Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)

Group: General Forum Members
Points: 73 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 Guru
SSC Guru (70K reputation)SSC Guru (70K reputation)SSC Guru (70K reputation)SSC Guru (70K reputation)SSC Guru (70K reputation)SSC Guru (70K reputation)SSC Guru (70K reputation)SSC Guru (70K reputation)

Group: General Forum Members
Points: 70827 Visits: 18528
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 Guru
SSC Guru (70K reputation)SSC Guru (70K reputation)SSC Guru (70K reputation)SSC Guru (70K reputation)SSC Guru (70K reputation)SSC Guru (70K reputation)SSC Guru (70K reputation)SSC Guru (70K reputation)

Group: General Forum Members
Points: 70827 Visits: 18528
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 :-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
Valued Member
Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)Valued Member (73 reputation)

Group: General Forum Members
Points: 73 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.

sgmunson
sgmunson
SSC Guru
SSC Guru (74K reputation)SSC Guru (74K reputation)SSC Guru (74K reputation)SSC Guru (74K reputation)SSC Guru (74K reputation)SSC Guru (74K reputation)SSC Guru (74K reputation)SSC Guru (74K reputation)

Group: General Forum Members
Points: 74816 Visits: 6361
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)
Smile Smile Smile
Health & Nutrition
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