Install or Uninstall the Reporting Services Add-in for SharePoint

Install the Microsoft SQL Server Reporting Services Add-in for SharePoint products on SharePoint servers to provide features that enable you to run a Reporting Services report server within a SharePoint deployment. Features include Power View, 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 products is a required component for a report server that runs in SharePoint mode. This topic contains the following sections:

For diagrams of example deployments with the add-in, see Install SQL Server BI Features with SharePoint 2013 (SQL Server 2012 SP1).

For a list of the versions of the add-in and download pages, see Where to find the Reporting Services add-in for SharePoint Products.

  • Prerequisites

  • What Does the Add-in Install?

  • Overview of the installation Methods

  • Install the add-in using rssharepoint.msi

  • How to Remove the Add-in

  • How to repair an installation

  • Log files

  • Upgrade

  • RsCustomAction.exe

Prerequisites

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. For more information about the complete set of requirements for using SharePoint mode, see Hardware and Software Requirements (PowerPivot for SharePoint and Reporting Services in SharePoint Mode). For more information on installing and configuring Reporting Services, see Install Reporting Services SharePoint Mode in a Single Server Farm.

If you are integrating Reporting Services with a SharePoint farm that has multiple Web front end applications, install the add-in 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.

To install the Reporting Services Add-in, you must be an administrator on the computer. For example if you are going to run the rsSharePoint.msi at the command prompt, you should open the command prompt with administrator privileges by using the Run as administrator option.

To install the Reporting Services Add-in, you must be a member of the SharePoint Farm Administrators group.

You must be a Site Collection administrator to activate the Reporting Services integration feature.

Arrow icon used with Back to Top linkTop

What Does The Add-in Install?

The add-in setup process is composed of two phases, both are completed automatically when you complete a standard installation:

  1. The first phase is to install files to the proper folders. The folders are standard for SharePoint deployments. One of the files that is installed is rsCustomAction.exe.

  2. The second portion of the installation is to run a set of custom actions to register the Reporting Services files with SharePoint. The custom actions are run from rsCustomAction.exe. The exe is removed when the full two phase installation completes. You can run a files only installation and rsCustomAction.exe is not run at the end of installation and it is left on the drive.

Arrow icon used with Back to Top linkTop

The installation order

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.

Note

The advantage of installing the add-in prior to the SharePoint product is that as new servers are added to the farm, the Reporting Services Add-in will be configured and activated by the SharePoint farm.

  • The SharePoint Products Preparation tool installs the SQL Server 2008 R2 version of the Reporting Services add-in. SQL Server 2012 includes a new version of the add-in that is required for SQL Server 2012 features.

    If you run the SharePoint Products Preparation Tool, you still need to install the SQL Server 2012 version of the Reporting Services Add-in.

  • If you install SQL Server 2012 version of the Reporting Services add-in first, then when you run the SharePoint Products preparation tool you will see the following dialog indicating the preparation tool did not install the older version of the add-in as the newer version was detected.

    SSRS add-in is already installed.

Overview of the Installation Methods

The SQL Server 2012 Reporting Services Add-in for SharePoint products can be installed using one of the following two methods:

  • The installation wizard: noteNew with SQL Server 2012, the add-in can be installed by the SQL Server installation wizard. Choose Reporting Services Add-in for SharePoint Products on the Feature Selection page of the wizard.

  • rsSharepoint.msi: The add-in can be installed directly from the installation media or downloaded and installed. The rsSharepoint.msi supports both a graphical user interface and a command line installation. You must run the .msi with administrator privileges by first opening a command prompt with elevated permissions, and then running the rsSharepoint.msi from the command line. For more information on downloading the add-in, see Where to find the Reporting Services add-in for SharePoint Products.

    Note

    If you use the /q switch for a silent command line installation, the end-user license agreement will not be displayed. Regardless of the installation method, the use of this software is governed by a license agreement and you are responsible for complying with the license agreement.

 

Arrow icon used with Back to Top linkTop

Install the add-in using the installation file rssharepoint.msi

This section is related to installing the rssharepoint.msi directly, by either running the .msi installation wizard or a command line installation. If you installed the add-in using the SQL Server installation Wizard, you do not need to follow these steps.

You can see a full list of command line switches by running the following command:

Rssharepoint.msi /?
  1. Download the Setup program (rsSharepoint.msi) for the Reporting Services Add-in. For more information on downloading the add-in, see Where to find the Reporting Services add-in for SharePoint Products.

  2. 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 folders under the following path and copies files to the folders:

    %program files%\common files\Microsoft Shared\Web Server Extensions\14\

    or

    %program files%\common files\Microsoft Shared\Web Server Extensions\15\

  3. Configure the report server settings and feature activation in SharePoint Central Administration. . For more information on installing and configuring Reporting Services SharePoint mode, see Install Reporting Services SharePoint Mode in a Single Server Farm.

Arrow icon used with Back to Top linkTop

Files-only installation

To install the files but skip the custom action phase of installation, run the rssharepoint.msi from the command line with the SKIPCA option.:

  1. Open a command prompt with administrator permissions.

  2. Run the following command:

    Msiexec.exe /i rsSharePoint.msi SKIPCA=1
    

The installation user interface will open and run as normal and the rsCustomAction.exe file is installed. However, the .exe will not run at the end of the installation and rsCustomAction.exe will remain on the computer when the installation is completed.

Arrow icon used with Back to Top linkTop

Use a Two-Step Installation to Troubleshoot Installation Issues

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 the custom actions executable. To run a two-step installation of the Reporting Services Add-in do the following:

  1. Open a command prompt with administrator permissions and run a files only installation as described in the previous section.

  2. Find the rsCustomAction.exe file on the file system. This file is copied to your computer by the Setup program. rsCustomAction.exe is located in the %Temp% directory. To get the path information for this file, Type the following from the command prompt:

    CD %temp%.

    The file should be located in: \Users\<your name>\AppData\Local\Temp

  3. Type the following command. This configuration step will take several minutes to finish. The W3SVC service will be restarted during this process. Several Status messages will be displayed as the program copies files, registers components, and runs the SharePoint Product Configuration Wizard.

    rsCustomAction.exe /i
    

Arrow icon used with Back to Top linkTop

Quiet installation for scripting

You can use the /q or /quiet switches for a “quiet” installation that will not display any dialogs or warnings. The quiet installation is useful if you want to script the installation of the add-in.

Note

If you use the /q switch for a silent command line installation, the end-user license agreement will not be displayed. Regardless of the installation method, the use of this software is governed by a license agreement and you are responsible for complying with the license agreement.

To perform a quiet installation:

  1. Open a command prompt with administrator permissions.

  2. Run the following command:

    Msiexec.exe /i rsSharePoint.msi /q
    

How to Remove the Reporting Services Add-in

You can uninstall the Reporting Services Add-in for SharePoint Products from Microsoft Windows control panel or the command line.

  1. Using control panel will run a complete uninstall of the files on the current computer AND it will remove the object and features from the SharePoint farm. When the object and features are removed you can no longer review and update reports.

  2. The command line method to uninstall the add-in allows you to use the LocalOnly parameter to only remove the add-in files from the local computer and the object and features in the farm will not be changed.

Uninstalling the add-in will remove server integration features that are used to process reports on a report server. It will also remove the Reporting Services pages from SharePoint Central Administration and other custom Reporting Services pages. You may also want to remove any reports and other report server items that you no longer use on the affected SharePoint sites. They will not run after the Reporting Services Add-in is removed.

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.

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.

Uninstalling the add-in 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), 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.

To Uninstall from Windows Control Panel

To start the wizard from Microsoft Windows Control Panel and remove the add-in:

  1. In Control Panel, in Programs, select Uninstall a Program

  2. Select Microsoft SQL Server RS Add-in for SharePoint. You can also start the uninstall wizard by running rssharepoint.msi from the command prompt with no switches.

  3. Click Remove.

Uninstall from the command line

To uninstall the add-in from the command line:

  1. Open a command prompt with administrator permissions.

  2. Run the following command:

    msiexec.exe /uninstall rsSharePoint.msi
    
  3. You will see a confirmation message box. Click Yes.

Uninstall the add-in from the local server only

The previous methods of uninstalling the add-in will remove the Reporting Services features and object from the farm. If you have a multi-server farm and want to uninstall the add-in from only the local computer and leave the SharePoint farm in a functional state, complete the following steps:

  1. Open a command prompt with administrator permissions.

  2. Run the following command:

    Msiexec.exe /uninstall rsSharePoint.msi LocalOnly=1
    

This will unregister the Reporting Services components from SharePoint and remove the files, but for the local computer only.

If you want to unregister the Reporting Services features from SharePoint but leave the files on the disk for use later, complete the following steps:

  1. Open a command prompt with administrator permissions.

  2. Run the following command:

    rsCustomAction.exe /p
    

The above steps assume you completed an installation of the .msi with SkipCA=1 and the rscusstomaction.exe is available. For more information, see the section describing the files only installation.

How to Repair rssharepoint.msi from the Command Line

To repair or uninstall the Reporting Services add-in using the command line, complete the following steps:

  1. Open a command prompt with administrator permissions.

  2. Run the following command:

    msiexec.exe /f rssharepoint.msi
    

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_SP_0.log. Each error in the log starts with the string "SSRSCustomActionError".

Note

AppData is a hidden folder in the Windows operating system. You may need to modify your Windows Explorer folder settings so you can see hidden files and folders.

View a log file with Windows Notepad

  • The following commands will change the command prompt path, list the rs log files and then open one of the files with Windows Notepad:

    cd %temp%
    
    Dir rs_sp*.log
    
    notepad rs_sp_3.log
    

View a Log file with PowerShell

  1. Type the following command from the SharePoint Management Shell to return a filtered list of rows from the file, that contain “ssrscustomactionerror”:

    Get-content -path C:\Users\<UserName\AppData\Local\Temp\rs_sp_0.log | select-string "ssrscustomactionerror"
    
  2. The output will look similar to the following:

    2011-05-23 12:40:12: SSRSCustomActionError: SharePoint is installed, but not configured.

Upgrade

If you have an existing installation of the Reporting Services Add-in, you can upgrade to the current version. The add-in setup will detect the existing version and prompt you to confirm the update. The message will be similar to the following:

A Lower version of this product has been detected on your system. Would you like to upgrade your existing installation?

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 different versions side-by-side the current version.

Arrow icon used with Back to Top linkTop

RsCustomAction.exe

The following table summarizes the rscustomaction.exe switches:

Switch

Description

i

Install the custom actions. This will register the Reporting Services components in SharePoint. This will restart the W3SVCservice.

r

Repair

u

Uninstall. This will unregister the Reporting Services components from the entire SharePoint farm but leave the files on disk. This will restart the W3SVCservice.

p

Local uninstall. This will unregister the Reporting Services components from only the local computer. The files will remain on disk. This will restart the W3SVCservice.

t

SQL Server Reporting Services 2005 only. The switch tests if the report server has a working connection to the report server database.

Configuring Reporting Services

After you have installed the add-in on all the necessary computers, you need to configure the report server from SharePoint Central Administration. The steps that are needed depend on the order which the different technologies were installed. For more information, see Install Reporting Services SharePoint Mode in a Single Server Farm and Reporting Services Report Server (SharePoint Mode)

See Also

Concepts

Install SQL Server BI Features with SharePoint 2013 (SQL Server 2012 SP1)

Install Reporting Services SharePoint Mode in a Single Server Farm

Reporting Services Report Server (SharePoint Mode)