I've had an application running for some time which accesses reports via the reportingservices web service. Recently I had a request to directly stream the reports for download rather than viewing them through the report viewer. I facillitated this using the reportexecutionservice web service and in testing, everything went fine. When deployed however, the downloads mysteriously failed to occur.
The issue traced to a 401 unauthorized error, which implies my network credentials were rejected. Easy, right? Well, the problem I'm having is that I'm using the same credentials for both the reportingservices web service and the reportexecutionservice web service and I had expected that what was sufficient for one was sufficient for the other.
The credentials I'm passing are for a user which is a member of the SQLServerReportServerUser group on the machine hosting the web service. Is this insufficient to run the reportexecutionservice, and if so, what do I need to do to adjust the security permissions of this user to grant them access to reportexecutionservice?
View Complete Post