How to: Install or Uninstall the Reporting Services Add-in
The Microsoft SQL Server Reporting Services Add-in for SharePoint 2010 products 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 deployment of Microsoft SharePoint Foundation 2010 or Microsoft SharePoint Server 2010 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, data sources and other report server content on a SharePoint site. The Reporting Services Add-in for SharePoint 2010 products is a required component for a report server that runs in SharePoint integrated mode.
The Microsoft SQL Server 2008 R2 Reporting Services Add-in for Microsoft SharePoint 2010 products is installed by the SharePoint 2010 Products Preparation tool (PreRequisiteInstaller.exe). If you want to download and install the add-in separately you can follow the instructions in this topic and for more information on downloading the add-in, see Where to find the Reporting Services add-in for SharePoint Products
A deployment of Reporting Services integrates with a deployment of a SharePoint 2010 product 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 that will be used to access report server content. 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 finishes 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 Share Point Central Administration to configure report server integration for all the Web front-end servers in the SharePoint farm.
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 2010 Integration and Requirements for Running Reporting Services in SharePoint Integrated Mode..
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.
Installation of the add-in
To install the Reporting Services Add-in, you must be an administrator on the computer.
You must be a Site Collection administrator to activate the Reporting Services integration feature.
In this release the add-in can be installed before installing SharePoint or after SharePoint installation. The add-in follows SharePoint pre-deployment standards and installs files in locations used by the SharePoint installation.
The advantage of installing the add-in prior to the SharePoint product or technology is that as new servers are added to the farm, the Reporting Services Add-in will be configured and activated by the SharePoint farm.
Installing the add-in before a SharePoint Product or Technology
The add-in must be installed on all servers that will run as SharePoint Web front-ends that you want integrated with the Reporting Services. If the SharePoint product or technology has not been installed yet, you can run the add-in installation wizard on all servers.
Download the Setup program (rsSharepoint.msi) for the Reporting Services Add-in.
As an administrator, run rsSharepoint.msi to run the Installation Wizard. The wizard displays a Welcome page, the Software license terms, and a registration information page. Setup creates SharePoint 2010 folders under %program files%\common files\Microsoft Shared\ and copies files to the folders. You must run the .msi as administrator by first opening an elevated command prompt window, and then running the rsSharepoint.msi from the command line.
Configure the report server integration settings and feature activation in SharePoint Central Administration.
Installing the add-in after a SharePoint Product or Technology has been installed
When installing the add-in on servers after a SharePoint product or technology has been installed, you can run the full add-in installation on only one of the SharePoint servers. For the other SharePoint servers in the farm, you must run the files only installation of the add-in from the command line. The files-only installation installs the files but skips the custom actions section of the installation process.
After you have installed the add-in on all the servers, start SharePoint Central Administration to configure report server integration.
To install the files but skip the custom action steps, run the .msi from the command line with the SKIPCA option:
Open a command prompt with administrator permissions.
Run msiexec -i rsSharePoint.msi SKIPCA=1.
Two steps for a full installation of the add-in
If you get errors during installation, you can run Setup as a two-step process from the command line. First run Setup to install the files and skip the custom actions, and then run a custom actions executable. To install the Reporting Services Add-in for files-only mode, do the following:
Open a command prompt with administrator permissions.
Run msiexec -i rsSharePoint.msi SKIPCA=1.
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.
Open a command prompt window. To do this, click Start, click Run, and type cmd. On newer operating systems, you might need to elevate your permissions and run this run this with administrator permission.
Navigate to the folder that contains the rsCustomAction executable.
Enter the following command. This configuration step will take several minutes to finish. The W3SVC service will be restarted during this process.
How to Remove the Reporting Services Add-in
You can uninstall the Reporting Services Add-in for SharePoint 2010 Products 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 SharePoint Foundation 2010 or SharePoint Server 2010 installation still running. If you uninstall the SharePoint 2010 first, you must reinstall it to uninstall the Reporting Services Add-in.
Removing the add-in from a server that is active in the farm removes the add-in from all servers in the farm. If you only want to remove the add-in from one server, first remove that server from SharePoint farm and then uninstall the add-in.
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.
In Control Panel, in Programs, select Uninstall a Program.
Select Microsoft SQL Server 2008 R2 Reporting Services SharePoint Add-in.
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 that is 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), shared data source (.rsds), and published report items (.rsc) 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.
How to Run rsSharePoint.msi from the Command Line
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.
Setup Log Files
When Setup runs, it logs information to a log file in the %temp% folder for the user who installed the Reporting Services Add-in. For example c:\Users\<username>\AppData\Local\Temp .The file name is RS_SP_<number>.log, for example RS_SP1.log. Each error in the log starts with the string "SSRSCustomActionError".
Edit the file from the command line
Type the following command at a command prompt:
Type the command Dir rs_sp*.log to see a directory listing of the log files.
Type the command notepad rs_sp_3.log to open the log file with Windows notepad.
Configuration and Activation
After you have installed the add-in, you need to Configure and review the feature activation from SharePoint Central Administration. For more information, see How to: Configure Report Server Integration in SharePoint Central Administration and How to: Activate the Report Server Feature in Site Settings
If you have an existing installation of the Reporting Services Add-in, you can upgrade to the current version. Setup will detect the existing version and prompt you to confirm the update. If you confirm, the older version of the add-in will be removed and then the new version will be installed.
Note that the Reporting Services Add-in is not instance-aware. You can only have one instance of the add-in on a computer. You cannot run early versions side-by-side the current version.