Skip to content

November 23, 2012


Install Reporting Services SharePoint Mode for SharePoint 2013

PowerView SQL 2012 and 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

2 Comments Post a comment
  1. Ali Dursun
    Mar 19 2013

    Hi Coskun,

    it doesn’t work, can’t clik on “System Settings” on SSRS Service App.
    Got following error message:

    Sorry, something went wrong
    The remote server returned an error: (503) Server Unavailable.
    Technical Details

    what could it be, any suggestions?

  2. Jul 8 2013

    A single server set up is useful for development and examining circumstances but it is not recommended for production surroundings.


Share your thoughts, post a comment.


Note: HTML is allowed. Your email address will never be published.

Subscribe to comments