Click to Rate and Give Feedback
TechNet
TechNet Library
SQL Server
SQL Server 2005
 Report Server Web Service Endpoints

  Switch on low bandwidth view
Community Content
In this section
Statistics Annotations (1)
Collapse All/Expand All Collapse All
SQL Server 2005 Books Online (November 2008)
Report Server Web Service Endpoints

The Report Server Web service provides several endpoints for managing a report server as well as executing and navigating reports.

With the installation of SQL Server 2005 Service Pack 2 (SP2) there are now two endpoints available for managing objects on a report server, ReportService2005 and ReportService2006. The ReportService2005 endpoint is used for managing objects on a report server that is configured for native mode. The ReportService2006 endpoint is used for managing objects on a report server that is configured for SharePoint integrated mode.

ms155398.note(en-US,SQL.90).gifImportant:
When a report server is configured for SharePoint integrated mode, the ReportService2005 APIs will return an rsOperationNotSupportedSharePointMode error. If the report server is configured for native mode, the ReportService2006 APIs will return an rsOperationNotSupportedNativeMode error.

ms155398.note(en-US,SQL.90).gifNote:
For backward compatibility, the Web service provided with Microsoft SQL Server 2000 Reporting Services is still provided. It can be accessed by using the URL http://<Server Name>/reportserver/reportservice.asmx?wsdl. Many of the classes and methods that were included in the earlier version of the Report Server Web service are included in the management endpoint.

The WSDL for the management endpoint can be accessed using the following URL:

http://<Server Name>/ReportServer/ReportService2005.asmx?wsdl

If the report server is configured for SharePoint integrate mode, the WSDL can be accessed using the following URL:

http://<Server Name>/<Site Name>/_vti_bin/ReportServer/ReportService2006.asmx?wsdl

For more information, see Accessing the SOAP API.

The ReportExecution2005 endpoint makes it easy for developers to customize report processing and rendering from a report server in both native and SharePoint integrated modes. The endpoint includes classes and methods that existed in earlier versions of the Report Server Web service. In addition, many new classes and methods have been added to the Report Server Web service that are exposed through the execution endpoint.

The WSDL for the management endpoint can be accessed using the following URL:

http://<Server Name>/ReportServer/ReportExecution2005.asmx?wsdl

If the report server is configured for SharePoint integrate mode, the WSDL can be accessed using the following URL:

http://<Server Name>/<Site Name>/_vti_bin/ReportServer/ReportExecution2006.asmx?wsdl

For more information, please see Accessing the SOAP API.

When a report server is configured for SharePoint integrated mode and the Reporting Services Add-in has been installed, a set of proxy endpoints are installed on the SharePoint server. The proxy endpoints are the primary API for developing report solutions when a report server is configured for SharePoint integrated mode. When developing against the proxy endpoints, the Reporting Services Add-in manages the exchange of credentials between the SharePoint server and the report server in Trusted account authentication mode. When developing against the report server endpoints, the calling application will have to manage the credential exchange in Trusted account authentication mode. The following table lists the endpoints that are installed with the Reporting Services Add-in.

Proxy Endpoint Description

ReportService2006

Provides the APIs for managing a report server that is configured for SharePoint integrate mode.

ReportExecution2005

Provides the APIs for running and navigating reports.

ReportServiceAuthentication

Provides the APIs for authenticating users against a report server when the SharePoint Web application is configured for Forms Authentication.

The following are example URLs for referencing the proxy endpoints on a SharePoint site.

http://<Server Name>/<Site Name>/_vti_bin/ReportServer/ReportService2006.asmx
http://<Server Name>/<Site Name>/_vti_bin/ReportServer/ReportExecution2005.asmx
http://<Server Name>/<Site Name>/_vti_bin/ReportServer/ReportServiceAuthentication.asmx
Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
There is no such thing as ReportExecution2006.asmx      Matt Olson   |   Edit   |   Show History

In the documentation above it says that you can go to: http://<Server Name>/<Site Name>/_vti_bin/ReportServer/ReportExecution2006.asmx?wsdl when using SharePoint Integrated mode.

There is no such thing as ReportExecution2006 web service. In SharePoint integrated mode you still use the ReportExecution2005 web service. The only difference between SharePoint Integrated mode and native mode is the management web service (ReportService2006 and ReportService2005).

Tags What's this?: Add a tag
Flag as ContentBug
Processing
© 2009 Microsoft Corporation. All rights reserved. Terms of Use | Trademarks | Privacy Statement
Page view tracker