E10 SSRS config help

Thanks Jose,

Turns out I had the application pool user set incorrectly. When I set the application pool to use a custom account and made sure that account had access to the report db it started to work.

Cheers
Brett

To the SSRS experts,


I am setting up E10 and need some help setting up SSRS reporting on the SQL server. Whenever I run a report it errors out with this exception "Program Ice.Services.Lib.RunTask raised an unexpected exception with the following message: RunTask: The request failed with HTTP status 401: Unauthorized.".


I can browse to the SSRS report manager website with no issues, I can see all the reports etc. I didn't get any errors when setting up SSRS but interestingly if I try to override the SSRS setting in company maintenance the "test Connection" button verifies ok but when I click save I get an error that the connection failed.


I must have some permission wrong somewhere but I am not sure where.


thanks in advance

Brett

Make sure your system task agent is set to impersonateÂ


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?

On Tue, May 26, 2015 at 8:32 AM, brett.manners@... [vantage] <vantage@yahoogroups.com> wrote:

Â
<div>
  
  
  <p></p><p><span>To the SSRS experts,</span></p><p><span><br></span></p><p><span>I am setting up E10 and need some help setting up SSRS reporting on the SQL server. Whenever I run a report it errors out with this exception &quot;Program Ice.Services.Lib.RunTask raised an unexpected exception with the following message: RunTask: The request failed with HTTP status 401: Unauthorized.&quot;.</span></p><p><span><br></span></p><p><span>I can browse to the SSRS report manager website with no issues, I can see all the reports etc. I didn&#39;t get any errors when setting up SSRS but interestingly if I try to override the SSRS setting in company maintenance the &quot;test Connection&quot; button verifies ok but when I click save I get an error that the connection failed.</span></p><p><span><br></span></p><p><span>I must have some permission wrong somewhere but I am not sure where.</span></p><p><br></p><p><span>thanks in advance</span></p><p><span>Brett</span></p><p></p>

</div>
 


<div style="color:#fff;min-height:0;"></div>