Install SQL Server 2012 Reporting Services Add-in For SharePoint 2010 and Sharepoint 2013

Reporting Service Add-in for SharePoint needs to be installed on all web front end servers and application servers in a SharePoint farm. This installation will deploy the necessary reporting service feature components in the server to support the following:

• PowerView
• Report Builder Integration with SharePoint Library
• Report Viewer Web part
• Features necessary for Report subscription, scheduling and data source management
• SharePoint Security Integration with Reporting Server Content
• Reporting Service Data Alert Integration with SharePoint.

You could take two approaches to install Reporting Service Add-In for SharePoint. The reporting service Add-In is part of the SQL Server installation package so you could use SQL Server installation package to install the Add-In or you could download the Reporting Service Add-In for SharePoint as a separate package and install it.

If you are installing in a Windows 2008 Server R2 then ensure Service Pack 1 is installed.

Approach 1: Download Reporting Service Add-In for SharePoint and Install it

As a first step of installation, download the Reporting Service add-in from Reporting Service Add-In for SharePoint . Once the download is complete, copy the installation package to the necessary servers in the SharePoint Farm.

• Step 1: Run the installer called RSSharePoint
  
  
  
• Click on "Next"
  
  
  
• Accept the license agreement and click on "Next"
  
  
  
• Click "Install"
  
  
  
• Wait for 5 to 10 minutes
  
  
  
• Click on "Finish"

Approach 2: Install Reporting Service Add-in using SQL Server Installation Package

• Step 1: Run the SQL Server Installer
  
  
  
• Click on the installation, and then click on "New SQL Server Stand-alone Installation" or "Add feature to an existing installation".
  
  
  
• Click "OK"
  
  
  
• Click "Next"
  
  
  
• Select "Perform a New installation"
  
  
  
• If you don't have a key then select evaluation, it doesn't matter because the Reporting Service Add-in is a free feature. And click "Next".
  
  
  
• Accept the license and click "Next".
  
  
  
• Select "SQL Server Feature Installation"
  
  
  
• Select only "Reporting Services Add-in for SharePoint Products" and click "Next".
  
• Click "Next" on a couple of more screens.
  
  
  
• Verify you are not installing only the necessary feature and click on the "Install" Button.
  
  
  
• Verify the completion report and click the "Close" button to finish the installation.
  
• Restart the machine.