SharePoint® 2010 Business Intelligence 24-Hour Trainer

10

Configuring Reporting Services for SharePoint Integration

Reporting Services integration with SharePoint has been available for several iterations of both tools now. With each version, configuring the integration has become much less problematic. Major steps have been taken to simplify the process so the integration is seamless. In this lesson you walk through the steps needed to configure either a new instance of Reporting Services for SharePoint integration or change an existing native mode instance of Reporting Services to SharePoint integrated mode.

CONFIGURING REPORTING SERVICES FOR SHAREPOINT INTEGRATED MODE

You may have noticed while stepping through the SQL Server installer that, if you included Reporting Services as part of the installation, the installer asked whether you would like to install in SharePoint integrated mode. Selecting Install the SharePoint Integrated Mode Default Configuration, shown in Figure 10-1, will save you the trouble of manually converting the report server databases, which are created with every installation of Reporting Services, to be in SharePoint integrated mode. When installing Reporting Services for the very first time this is all you must do to have it ready for SharePoint integration.

If you have previously installed Reporting Services in native mode, without SharePoint integration, you must manually make the switch to integrate the two products. To start the process of manually converting from native mode to integrated mode, open ...