SQL reporting services reference

Question

Hi everyone,

I want to add service reference to SQL reporting services on local machine. In Reporting Service Configuration Manager under Web Service URL tab I have report service URL exposed, I have tried to add web reference to project with that Web Reference URL, but it can not be found.

Please tell me am I missing something or is this right way to to?

Thanks a lot.

Answer 1

There are two kind of address in SSRS, (youcan find them on SSRS Configuration Tool)

 //localhost:xxxx/Reports

and

 //localhost:xxxx/ReportServer

you have to use ReportServer

Answer 2

First of all, you should try this url: http://localhost/ReportServer/ReportService.asmx?WSDL

WSDL at the end of the url is very important, because only by this querystring web-service will return the Web-Service Definition for the reporting services reference.

Other way, in "Add web-reference" dialog you can choose the "Web services on the local machine" (see the picture), and choose your service there.

Additional information about permissions needed is here: http://msdn.microsoft.com/en-us/library/ms169816.aspx

Answer 3

Use this:

http://server/reportserver/ReportService2005.asmx?wsdl

ref: http://msdn.microsoft.com/en-us/library/ms154052.aspx