How to: Activate the Report Server Feature in SharePoint Central Administration
New: 15 September 2007
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. To configure report server integration, you use the Reporting Services pages in Central Administration's Application Management tab.
If the Reporting Services section is not visible in Application Management, the Reporting Services Add-in is either not installed or the report server integration settings are not activated.
By default, the Reporting Services Add-in 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, you must activate the report server integration settings manually.
To activate Reporting Services integration on a Site Collection
Click Start, click Administrative Tools, and then click SharePoint 3.0 Central Administration.
Click Site Actions.
Click Site Settings.
Click Site Collection Features.
Find Report Server Integration Feature in the list.
After the feature is activated, you can continue with server integration. For instructions, see How to: Configure the Report Server Integration Feature in SharePoint Central Administration.
If Report Server Integration Feature is not in Site Collection Features, an error occurred during setup. To verify installation, view the list of installed applications in Add and Remove Programs and then check the Setup log file for error information. When Setup runs, it logs information to a log file in the %temp% folder for the user who is installed the Reporting Services Add-in The file name is RS_SP_<number>.log. Each error in the log starts with the string "SSRSCustomActionError".