Using the SOAP API in a SharePoint Application

New: 12 December 2006

A new set of endpoints have been provided with the installation of SQL Server 2005 Service Pack 2 (SP2) that will allow development of reporting solutions that are tightly integrated with Microsoft Windows SharePoint Services 3.0 or Microsoft Office SharePoint Server 2007. These endpoints are installed by both the (SP2) installation as well as the Reporting Services Add-in for SharePoint Technologies. For more information on how to configure Reporting Services in SharePoint integrated mode see Configuring Reporting Services for SharePoint 3.0 Integration.

Report Server Endpoints

When SQL Server 2005 (SP2) is applied to an installation of Reporting Services, the new ReportService2006 endpoint will be available on the report server. This endpoint provides the management APIs for a report server that is configured for SharePoint integrated mode.


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.

Although a new endpoint was added for managing a report server in SharePoint integrated mode the existing ReportExecution2005 endpoint will continue to work in both native and SharePoint integrated modes. The following is an example URL for referencing the ReportService2006 endpoint on a report server.

http://<Server Name>/ReportServer/ReportService2006.asmx

SharePoint Proxy Endpoints

In addition to the report server endpoints, a set of proxy endpoints are installed on the SharePoint server when the Reporting Services Add-in is installed. 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 handles 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


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


Provides the APIs for execution and navigation of reports.


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

See Also

Other Resources

Reporting Services and SharePoint Technology Integration

Help and Information

Getting SQL Server 2005 Assistance