Enable Reporting Services in an integrated SharePoint Server BI test environment

Applies to: SharePoint Server 2010 Enterprise

In our baseline configuration, SQL Server Reporting Services is installed in native mode. To use any of the Reporting Services features on SharePoint Server such as PowerPivot, Access Services, or Report Builder 3.0, you must change your configuration of SQL Server Reporting Services to SharePoint integrated mode. The articles in this section instruct how to change from native to integrated mode and how to configure and start Report Builder 3.0 from the Business Intelligence Center.

In this section:

• Changing SQL Reporting Services from Native mode to Integrated mode in a BI test environment

• Configure Report Builder 3.0 for use in SharePoint BI test environment