SharePoint Coskun

Install Reporting Services SharePoint Mode for SharePoint 2013

So you installed SQL 2012 and SharePoint 2013 but you don’t know how to get Reporting Services working so you can use Power view? Well no worries here is a summary of what you need to do.

First, Install the Service

The first thing you need to make sure you do is install the service on SharePoint. Run the following PowerShell commands in SharePoint 2013 Management Shell as an administrator.

1. Install-SPRSService
2. Install-SPRSServiceProxy
3. get-spserviceinstance -all |where {$_.TypeName -like “SQL Server Reporting*”} | Start-SPServiceInstance

Second, Create the Service Application

After you install the service in Central Administration you will now have the option to create a new SQL Server Reporting Services Service Application.  Go to  Application Management group, click Manage Service Applications and create a new service application. If you don’t see this option that means the above steps weren’t successful in creating the service. So make sure you have that completed before you try to create a new service application.

Third, Activate the Powerview Feature

To activate the feature, go to the site collection features and find the feature Power View Integration Feature  in the list and click Activate.

———

For detailed step by step how to visit the MSDN article - Install Reporting Services SharePoint Mode as a Single Server Farm