The only way that I have been able to connect to the Report Server from Excel is by changing the Report Server to anonymous access in IIS. That is unacceptable because it allows all users access to all reports on that server. I have administrator privileges on the Report Server machine and am able to access everything other than this.
The request failed with HTTP status 401: Unauthorized.
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object parameters)
at Aspose.Cells.ReportingServices.Services.ReportingService.ReportingService2005.ListChildren(String Item, Boolean Recursive)
This message was posted using Aspose.Live 2 Forum