How to: Install the Reporting Services Add-in

New: 15 September 2007

The Microsoft SQL Server 2005 Reporting Services Add-in for SharePoint Technologies is a required component for a report server that runs in SharePoint integrated mode.

You can download and install the Reporting Services Add-in on a Windows SharePoint Services 3.0 or Microsoft Office SharePoint Server 2007. The Reporting Services Add-in provides application pages, a proxy URL endpoint, and program files that support integration with a SQL Server 2005 Reporting Services SP2 report server.

You can install the Reporting Services Add-in in files-only mode. A files-only installation is necessary only if Setup fails and you are troubleshooting installation problems.

Before you install the Reporting Services Add-in, read Installing the Reporting Services Add-in to learn more about the Setup log files, language support, and installation requirements.

  • Download the Reporting Services Add-in to a server that has an instance of the SharePoint product or technology. You can download the Reporting Services Add-in from the Microsoft Download Center.

  • Navigate to the folder that contains downloaded files.

  • Double-click SharePointRS.msi to run the Installation Wizard. The wizard displays a Welcome page, the license agreement, and a registration information page. Click Install to run Setup.

  • Use SharePointRS.msi -r to repair an existing installation.

  • Use SharePointRS.msi -u to uninstall an existing installation of the Add-in. Additional steps must be followed to completely uninstall the Add-in. For more information, see How to: Uninstall the Reporting Services Add-in.

  1. Run SharePointRS.msi SKIPCA=1. A files-only installation runs the Installation Wizard.

  2. Find the rsCustomAction.exe file on the file system. This file is copied to your computer by the Setup program. The file will be located in the %Temp% directory.

    To get the path information for this file, click Start, click Run, and then type %temp%. The file should be located in \Documents and Settings\<your name>\LOCALS~1\Temp.

  3. Open a command prompt window. To do this, click Start, click Run, and type cmd.

  4. Navigate to the folder that contains the rsCustomAction executable.

  5. Enter the following command:

    rsCustomAction.exe /i

    This configuration step will take several minutes to complete. The W3SVC service will be restarted during this process.

  6. Configure the report server integration settings in Central Administration. For instructions, see How to: Configure the Report Server Integration Feature in SharePoint Central Administration.