Export (0) Print
Expand All
Expand Minimize

How to: Install or Uninstall the Reporting Services Add-in

The Microsoft SQL Server 2008 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 URL proxy endpoint, and application pages so that you can create, view, and manage reports, report models, and other report server content on a SharePoint site. The Reporting Services Add-in for SharePoint Technologies is a required component for a report server that runs in SharePoint integrated mode.

Important noteImportant

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. It is recommended to use the Installation Wizard to install the Reporting Services Add-in on one of the Web front-end computers first. Then use the files-only mode installation to install the add-in sequentially on the other Web front-end computers in the farm. After one files-only installation completes successfully, start the installation on the next Web front-end computer, and so on until you have completed the installation on all Web front-end computers in the SharePoint farm. Then, start Central Administration to configure report server integration for all the Web front-end servers in the SharePoint farm.

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. Log on as a SharePoint farm administrator to install the Reporting Services Add-in.

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

  3. Download the Reporting Services Add-in to a server that has an instance of the SharePoint product or technology.

    1. Go to the SQL Server 2008 Reporting Services Add-in for SharePoint Technologies page on the Microsoft Download Center.

    2. Select the language version you want to install. The Report Viewer Web Part (ReportViewer.dwp) will be available only in the language that you choose. The application pages and messages will be available in all supported languages, regardless of the language you select on the Download page. For more information about supported languages, see Solution Design Considerations for Multi-Lingual or Global Deployments (Reporting Services).

    3. In the Files in this Download section, click Download to install the rsSharepoint.msi.

  4. If you are integrating Reporting Services with a SharePoint farm that has multiple Web front end applications, copy or download the rsSharepoint.msi to each computer in the farm that has a Web server front-end. Do this only for Web front ends that will be used to access report server content.

Run rsSharepoint.msi 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. You can use the Installation Wizard to install the Reporting Services Add-in, or run Setup from the command line and specify command line arguments for a files-only mode installation.

Setup does not configure the server for integration with Reporting Services. You must configure integration after Setup is complete. Setup uses the existing folder structure of the current deployment and creates a new folder for the Reporting Services Add-in application files.

  1. Navigate to the folder that contains rsSharePoint.msi.

  2. Double-click rsSharePoint.msi to run the Installation Wizard. The wizard displays a Welcome page, the license agreement, and a registration information page.

  3. Click Install to run Setup.

  4. After Setup is finished, go to Administrator Tools and click SharePoint 3.0 Central Administration.

  5. 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: Configure Report Server Integration in SharePoint Central Administration.

You can install the Reporting Services Add-in in files-only mode if you encountered errors during a normal Setup. In files-only mode, Setup will run the Installation Wizard to copy the application files to your computer. After the files are copied, you must run custom actions to complete the installation.

  1. Run rsSharePoint.msi SKIPCA=1.

  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. After Setup is finished, go to Administrator Tools and click SharePoint 3.0 Central Administration.

  7. 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: Configure Report Server Integration in SharePoint Central Administration.

You can uninstall the Reporting Services Add-in for SharePoint Technologies by running the Setup program (rsSharepoint.msi)) in uninstall mode. Uninstalling the add-in will remove server integration features that are used to process reports and models on a report server.

To uninstall the Reporting Services Add-in, you must have a Windows SharePoint Services or Office SharePoint Server 2007 installation still running. If you uninstall the SharePoint product or technology first, you must reinstall it to uninstall the Reporting Services Add-in.

  1. On the SharePoint site, remove any reports and other report server items that you no longer use. They will not run after the Reporting Services Add-in is removed.

  2. In Control Panel, in Add and Remove Programs, select Microsoft SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies.

  3. Click Remove.

The steps for uninstalling the add-in are the same for both stand-alone servers and server farms. Setup will remove program files and any configuration settings that were added during installation.

Setup will not remove the following:

  • Logins created for the Report Server service account used to access the SharePoint configuration and content databases. You must delete any logins for the Report Server service account from the SQL Server Database Engine instance used to host the SharePoint databases.

  • Permissions or groups that you created for report users. If you created custom permission levels or SharePoint groups to grant access to report server features, you should revoke any permissions that are no longer required.

  • Data files that you uploaded to a SharePoint library, including report definition (.rdl), report model (.smdl), and shared data source (.rsds) files. They are not deleted, but they will no longer run. You must delete the files manually.

  • Setup will not delete the report server database or modify the report server instance that was used for integrated operations. After you uninstall the add-in, consider switching the report server to run in native mode if you want to use the instance as a stand-alone reporting application.

You can run Setup from the command line to repair or uninstall the Reporting Services Add-in.

  • Run rsSharePoint.msi -r to repair an existing installation.

  • Run rsSharePoint.msi -u to uninstall an existing installation of the Add-in.

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

Updated content

Updated introduction with important note about how best to install the Reporting Services Add-in in a SharePoint farm.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft