Skip to content

November 23, 2012

6

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

6 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?

    Reply
    • Simon Davidson
      Mar 5 2014

      Hello Ali, I’m getting the same error, did,you find a resolution?
      I have 3 servers, Sharepoint 2013 WFE / App server, SQL Server 2012 Standard database server (SharePoint Databases) and a SQL Server 2012 Standard BI server where SSRS is installed. I have SSRS Sharepoint add-in installed on WFE and BI server. Ran Install-SPRS* on WFE and BI servers, and have SSRS SharePoint mode installed on the BI Server. SharePoint 2013 has the March CU applied, and SQL Server has SP1 and the non security patches applied. Only the BI server is running SQL Reporting Server app, and says it was provisioned correctly. Finally, I’m using a least privileged account model so each service and the farm are using unique service accounts.

      Any help greatly appreciated!

      Reply
  2. Jul 8 2013

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

    Reply
  3. harshad
    Jul 30 2013

    Same error message i have received

    Someone help me what could it be, any suggestion??

    Reply
  4. Ed
    Oct 17 2013

    Thanks great article and video. Worked like a dream once installed SQL Server 2012 SP1 and CU.

    Reply
  5. Ndix Mbaya
    Dec 20 2013

    Did you manage to solve the problem Ali?

    Reply

Share your thoughts, post a comment.

(required)
(required)

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

Subscribe to comments