Wednesday, March 26, 2014

SQL Reporting services Installation with SharePoint 2013

SQL Reporting services Installation with SharePoint 2013

As we all know that we use Reporting services integrated with SharePoint. The Installation and configuration of reporting services with SharePoint 2010 is pretty straight forward but there are many changes in reporting services that to integrate with the SharePoint 2013. This post will walk through the steps required to set up SQL Server Reporting Services in Integrated mode with SharePoint 2013.

To start with, it’s important to understand that SSRS will install as a SharePoint service application. This obviously means that it must be installed on a machine that is part of the  SharePoint farm. In a single SharePoint front end environment it is much better to add SSRS to your SharePoint server than it is to add SharePoint to your SQL server. Obviously, if you have a separate SharePoint application server, that’s the best place for it.

To install and configure the Reporting services, we need to have SQL Reporting features and the SharePoint 2013 Installation  on the server.

·        SQL 2012
·        SharePoint 2013

How to Install the SQL reporting service Feature:

Follow the below article on how to install the shared feature for SQL

http://expertsharepoint.blogspot.de/2014/03/how-to-add-shared-feature-in-sql-2012.html

Check the Boxes as per the screen shot below to get the Reporting services feature.         


How to Install the SharePoint 2013:

Follow the below article on how to install the SharePoint.


After the Installation of SQL Feature and SharePoint:

Here, we need to consider two things to get the Reporting services feature

1.   Install SharePoint First and then the Reporting services feature, Then You can see the Reporting Service Application Under Application management->service Applications

2.   Another thing that you should note is that the order of operations is important here. If you install Reporting Services prior to SharePoint  installation in the SharePoint on the farm, the option to create a Reporting Services application will not appear under the service application in SharePoint. That’s because it won’t be registered with the farm as a service application. If this happens, you can run the following Power Shell to register the Service Application

Go to SharePoint Management shell and run the below power shell commands.

Install-SPRSService
Install-SPRSServiceProxy

The next thing you need to do is to provision the service application from central administration.

Go to central administration->application management->Manage Service applications->Click on New on Ribbon


You can see the SQL server Reporting services Application, Click on the Service and fill out the details And select OK. Ensure  that you navigate to the bottom of the form and select the applications to activate SSRS on
Once the service application and proxy have been created, click on it to access the management screen.



You’ll want to access each of the sections and fill out the appropriate options for your installation. you should back up your encryption key in the key management section, Set your unattended execution account, and your email server settings if you want to be able to deliver reports via email. If you want to enable self service subscriptions and alerts, fill out that section, and it contains instructions for setting up the SQL agent service to support it.


The most important section is System Settings, which controls the bulk of how Reporting Services will run. Clicking on it accessed the service itself, 

If you can access your system settings, then you should be good to go. The next step is to enable SSRS in your site collections. To do this, Go to Every site>site settings->Check the Report services Option and enable settings.

That’s It. Your good to access the Reports now.

Please Comment if you need Any Help.Your Feed back is always Welcome.I Am Happy to Help !!!!!

2 comments:

  1. Parimala TharationApril 3, 2014 at 10:54 PM

    its a new way compare to 2010.Thanks for the detailed article avula

    ReplyDelete
  2. Appears to be mostly plagiarized from here: http://whitepages.unlimitedviz.com/2012/07/setting-up-reporting-services-2012-with-sharepoint-2013/

    ReplyDelete

Your feedback is Much Appreciated. I will try to reply to your queries as soon as possible!!Anil Avula

ShareThis

X