CODEWITHSUNDEEP
sql-serverreporting-servicesweb-reference
eomeroff
eomeroff

Reputation: 9925

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 something or is this right way to to?

Thanks a lot.

Upvotes: 1

Views: 7391

Answers (3)

Raj Kaimal
Raj Kaimal

Reputation: 8304

Use this:

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

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

Upvotes: 2

VMAtm
VMAtm

Reputation: 28366

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

Upvotes: 0

Nasser Hadjloo
Nasser Hadjloo

Reputation: 12630

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

Upvotes: 1

Related Questions