Report server integration settings are configured in SharePoint Central Administration after you install the Microsoft SQL Server 2005 Reporting Services Add-in for SharePoint Technologies. Before you can configure integration, the report server integration feature must be activated. If you start Central Administration and the Reporting Services section is not visible in Application Management, the Reporting Services Add-in is probably not activated.

Note:  By default, the feature is activated for the root site collection of the local SharePoint Web application. If the root site is not enabled or if you do not have a site collection defined when the Reporting Services Add-in is installed, the feature is not activated.

  1. Click Start, click Administrative Tools, and then click SharePoint 3.0 Central Administration.

  2. Click Site Actions.

  3. Click Site Settings.

  4. Click Site Collection Features.

  5. Find Report Server Integration Feature in the list.

  6. Click Activate.