Installing the Reporting Services Add-in

SQL Server Setup

previous page next page

New: 12 December 2006

The Microsoft SQL Server 2005 Reporting Services Add-in for SharePoint Technologies is a Web download that you can install on a server that has an instance of a SharePoint product or technology. It provides a set of features that enable you to run a report server within a larger deployment of Microsoft Windows SharePoint Services 3.0 or Microsoft Office SharePoint Server 2007.

Features include a Report Viewer Web Part, a proxy server endpoint, and application pages so that you can create, view, and manage reports, report models, and other report server content on a SharePoint site.

You must be a SharePoint farm administrator to install the Reporting Services Add-in.

Preparing to Install

Installing the Reporting Services Add-in is one of many steps that are necessary for integrating a report server with an instance of a SharePoint product or technology. For more information about the complete set of steps, see Configuring Reporting Services for SharePoint 3.0 Integration. The order of steps for configuring the servers is important. For best results, be sure that you do them in order.

To prepare to install the Reporting Services Add-in:

  1. Verify that you have two server installations - a report server and a SharePoint server - that meet the requirements for integrated operations. For more information, see Requirements for Running Reporting Services in SharePoint Integrated Mode.
  2. 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.
  3. If you are integrating a SharePoint farm with a report server deployment, copy or download the Reporting Services Add-in to each computer in the farm that has a Web server front-end.

Installing the Reporting Services Add-in on a Standalone Server

  1. Run Setup.exe on a computer that has the Web front-end for a deployment of the SharePoint product or technology that you want to configure for report server integration.
    Setup does not provide options for customizing an installation. Setup uses the existing folder structure of the current deployment when adding new files. Setup first verifies whether Windows SharePoint Services 3.0 is installed. Then Setup copies the application files and the proxy server endpoint to the new folder.
    A Setup program (.msi) file installs the Reporting Services Add-in in all supported languages. There is no language-specific Setup program. Application files for all supported languages are installed when you run Setup.
    Setup does not configure the server for integration with Reporting Services. You must configure integration after Setup is complete.
  2. After Setup is finished, go to Administrator Tools and click SharePoint 3.0 Central Administration.
  3. Click Application Management. You should see a new section named Reporting Services. This section has links to pages used to specify integration settings. For instructions on how to specify the settings, see How to: Set Report Server Integration in SharePoint Central Administration.

Installing the Reporting Services Add-in on Virtual Servers in a SharePoint Farm

A deployment of Reporting Services integrates with a deployment of a SharePoint product or technology at the farm level. If you have multiple SharePoint Web applications in a farm configuration, you must install the Reporting Services Add-in on each computer that has a Web front-end. After you have installed the add-in on all computers, start Central Administration to configure report server integration for all the servers in the farm.

Command Line Arguments

You can append arguments to run Setup in an installation mode.

  • 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

Setup Log Files

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

See Also

previous page start next page