I have a Windows service that run as Local System account. The service uses the Reporting Services ReportService2005.asmx web service.
When I have SQL Server 2008 installed, I have no problems and my service is able to browse and create report.
After I have installed SQL Server 2008 R2 I get the error "The request failed with HTTP status 401: Unauthorized." when the service tries to use the web service. If I change my service to log on as a user with administrator rights, it is able to use
Reposting Services again.
What has changes in SQL Server 2008 R2, that doesn't allow the Local System account to use Repoting Services? And is it possible to configure Reporting Services to allow it?
View Complete Post