SharePoint 2013: How to Configure SQL Server Reporting Services 2012

SharePoint 2013: How to Configure SQL Server Reporting Services 2012

Today I want to highlight the following subject: “SQL Server Reporting Services”. 
The procedures in this topic guide you through a single server installation of a Reporting Services report server in SharePoint mode. The steps include running the SQL Server installation wizard as well as additional configuration tasks that use SharePoint 2013 central administration. The topic can also be used for individual procedures for updating an existing installation, for example to create a Reporting Services service application.

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.

If you want to know how to configure it on SharePoint 2010; please refer to http://www.gknzcfc.net/subsite/how-to-configure-reporing-services-in-sharepoint2010.html

 

1. The first step you should do is connecting to the SQL server and open “Reporting Services Configuration Manager”

2. Secondly specify a Managed User and click on apply.


3. When Reporting Services Configuration Manager accepts the User that you provided please go to the following page “Web Service Url” and provide the following

    1. Virtual Directory:            ReportServer_MSSQLSP2013
    2. IP Address:                    All Assigned (Recommended)
    3. TCP port:                       80
    4. SSL Certificate:               (Not Selected)

 

4. After providing all the information that Reporting Services needs you can click on apply and you should see appear “creating virtual directory” and “url was successfully reserved

5. Now, on the next tab please click “Database”. Actually you should see that any of the following has been filled. If this is the case do not worry J

6. Click on “Change Database



7. There should be a new wizard on the screen asking you a few questions. On the first question please select “Create a new report server database

8. Click Next


9. The wizard is going to ask you a user for his connection. Actually, this should be prefilled. In other cases you can use your SQL Administrator (setup user ) for succeeding your connection.



10. At this level the wizard is going to ask us a Database name and the language of our Database.
    1. Database Name:                       ReportServer (feel free to change)
    2. Language:                                 English (United States) (feel free to change)

11. Click Next


12. Provide now a Service Credential to run you’re Reporting Services. Please do not like me, and don’t be lazy and create a realManaged Account =^)

13. Click Next



14. Finally, this was the last step and now you can install your Report Server.

15. After a while, you should see on each value a “success

16. If this is the case you can click finish and close the wizard


17. Again on our screen you can now see the page filled with all the information that we provided.
    1. SQL Server Name:                               SRV-DB-GKM
    2. Database Name:                                   ReportServer
    3. Report Server Mode:                            Native
    4. Credential:                                            Service Account
    5. Login:                                                   Sppirate\spfarm
    6. Password:                                             ****************

 


18. This is the last screen of configuration on Reporting Services Configuration Manager. Provide a Virtual Directory and click on Apply.

19. Again you should see “Creating Virtual Directory” and “The URL was successfully reserved

 


20. Finally our configuration is terminated. On the summary screen you should see that the service is started and filled with all correct information.


21. To check if everything ran smoothly, please connect to your Report Server URL and Web Service URL. Actually there should be any error and the 2 pages should show up without any error.

  


22. We have to configure Reporting Service now on our SharePoint Server but there is a little problem. We configured our SSRS after configuring SharePoint and SharePoint Server has any idea about what SSRS is.

23.So Microsoft tells us to execute the following PowerShell scripts to create our Service Application.

    1. Install-SPRSService
    2. Install-SPRSServiceProxy
    3. get-spserviceinstance -all |where {$_.TypeName -like “SQL Server Reporting*”} | Start-SPServiceInstance
But as you can see our cmdlets are not recognized. The resolution of this is to install SQL Server 2012 SP1 and the cmdlets will be recognized and you can install your service application.


24. Connect to your Central Administration

25. Go to Manage Service Application

26. And create the new service “SQL Server Reporting Services Service Application


27. As, as many of yours knows this screen, you have to fill some information before creating your service application.
    1. Name:                           SQL Server Reporting Services – gknzcfc.net
    2. Application Pool:           Intranet – gknzcfc.net
    3. Configurable:                 SPPIRATE\svcacc_sp_ssrs
    4. Database Server:           SRV-SPSQL-GKM\MSSQLSP2013
    5. Database Name:            SQLServer_ReportingService_DB

  

Leave a Comment
  • Please add 5 and 7 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • Ed Price - MSFT edited Revision 1. Comment: Title, tags

  • Ed Price - MSFT edited Original. Comment: Technical voice, title, tags

Page 1 of 1 (2 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • You need to clarify this article.  According to TechNet (msdn.microsoft.com/.../gg492276.aspx):

    "The Reporting Services Configuration Manager is no longer required or supported to configure and administer Reporting Services SharePoint mode. Use SharePoint Central Administration to configure a report server in SharePoint mode."

    Your article incorrectly directs users to configure SSRS 2012 using the Reporting Services Configuration Manager.  This is no longer the case in SQL 2012/SP 2013.  The wizard actually fails with an error.

    This article would be appropriate if the SQL Reporting instance was SQL 2008 R2.  Then you would need to uses the Reporting Services Configuration Manager.

  • Ed Price - MSFT edited Original. Comment: Technical voice, title, tags

  • Ed Price - MSFT edited Revision 1. Comment: Title, tags

Page 1 of 1 (3 items)