Install and configure Reporting Services 2014 for SharePoint 2013

Marcin Siewnicki

SQL Server Reporting Services feature can be installed on SharePoint farm. In this article I will describe required steps to install and configure SQL Server Reporting Services 2014 on SharePoint 2013.

There are many combinations of SharePoint and Reporting Services version. Full table is available on MSDN site – Supported Combinations of SharePoint and Reporting Service and Add-in.

I will describe the latest version of SQL Server Reporting Services (2014) and SharePoint 2013.

Three main steps:

  1. Installing the Reporting Services in SharePoint integrated mode
  2. Installing the Reporting Services Add-In for SharePoint Products
  3. Create and configure SharePoint Service Application

Installing the Reporting Services in SharePoint integrated mode.

This installation must be made on every SharePoint Application server that will run Reporting Services Service Application in your farm.

  1. Mount SQL Server 2014 media and run setup. Choose Installation from the left menu.
  2. Launch a wizard by clicking New SQL Server stand-alone installation or add features to an existing installation.
    sqlrs_1
  3. Enter your product key and click Next.
  4. Accept license terms and click Next.
  5. If your server is connected to the Internet you can use Microsoft Updates to check for available updates. Click Next.
    sqlrs_2
  6. The Install Rules page validates system prerequisites. Check if there are any errors and fix them. Click Next.
    sqlrs_3
  7. Choose SQL Server Feature Installation from Setup Role page. Click Next.sqlrs_4
  8. Check Reporting Services – SharePoint, change feature directory if required. Click Next.
    sqlrs_5
  9. Review the Reporting Services ConfigurationInstall only option in Reporting Services SharePoint Integrated Mode must be selected.
    sqlrs_6
  10. Validate Feature Configuration Rules and fix any errors. Click Next.
  11. Review configurations and click Install.
  12. Click Close on the Complete page.
    sqlrs_7

Installing Reporting Service Add-Inn for SharePoint Products.

The second part of prerequisites is the Reporting Services Add-In. You can install it from SQL Server 2014 media disk or download it from Microsoft Download Center.

This installation must be made on every Front-End server in your farm.

Installation steps:

  1. Run rsSharePoint.msi file
  2. Click Next on Welcome page.
  3. Accept terms and click Next.
  4. Click Install.

Create and configure SharePoint Service Application

  1. Run SharePoint 2013 Management Shell and execute cmdlet Install-SPRSService to install the reporting service.
  2. Run Install-SPRSServiceProxy to install the service proxy.
  3. Go to Central Administration -> System Settings -> Manage services on server and start SQL Server Reporting Services Service, or run this Powershell command
    Get-SPServiceInstance -All | where {$_.TypeName -like “SQL Server Reporting*”} | Start-SPServiceInstance
  4. Go to Central Administration -> Application Management -> Manage service applications and create the new SQL Server Reporting services Service Application.
    sqlrs_9

Now we can go and prepare our first report and deploy it to the SharePoint farm.

In the next article we will discuss reporting configuration options, create our first report and deploy it to SharePoint.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s