SQL reporting services reference
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 somethi开发者_运维问答ng or is this right way to to?
Thanks a lot.
Use this:
http://server/reportserver/ReportService2005.asmx?wsdl
ref: http://msdn.microsoft.com/en-us/library/ms154052.aspx
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
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.
alt text http://img706.imageshack.us/img706/2387/solution.png
Additional information about permissions needed is here: http://msdn.microsoft.com/en-us/library/ms169816.aspx
精彩评论