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

  • 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.

Install the Reporting Services Add-in Using the Installation Wizard

  • 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.

Install the Reporting Services Add-in Using Command Line Arguments

  • 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.

Install the Reporting Services Add-in in Files-only Mode

  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.

See Also

Tasks

How to: Uninstall the Reporting Services Add-in
How to: Install a SharePoint Web Front-End on a Report Server Computer

Concepts

Installing the Reporting Services Add-in

Other Resources

Deployment Modes for Reporting Services
Requirements for Running Reporting Services in SharePoint Integrated Mode
Configuring Reporting Services for SharePoint 3.0 Integration
Reporting Services Installation How-to Topics

Help and Information

Getting SQL Server 2005 Assistance