How to use WebService of SQL Server 2008 Reporting Services

Question

I created a report and published it to the Report Server 2008 that worked fine. I can call http://servername:81/Reports in my browser and view and export the reports. What I want to do now is write an application that uses the report to create a Excel file out of it.

According to the Reporting Services Configuration Manager the WebService of that Report Server is located at http://servername:81/ReportServer. When I open the link in my browser I can see the folders of the projects I created and deployed using Visual Studio.

But I can't find a web service endpoint there. In VS when I try to add a web reference no web service can be found there either.

What am I missing here?

Answer 1

Maybe you haven't specified the .asmx (web service) address...

This MSDN article is from the SQL Server 2008 Books Online which should be useful. Also note the "Other Resources" link to Building Application using the Web Service...

Just checking the config file for one of our applications that uses the web service and the address stored is:

http://SERVER_NAME/ReportServer/ReportService.asmx

so yours might be:

http://SERVER_NAME:81/ReportServer/ReportService.asmx