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.
http://3.bp.blogspot.com/-ijRSqo9xQxI/UzOd3zfJJvI/AAAAAAAABtc/IMEU8yYClnI/s1600/7.bmp
How to Install the SharePoint 2013:
Follow the below article on how to install the SharePoint.
http://expertsharepoint.blogspot.de/2013/11/detailed-sharepoint2013-installation-i.html
After the Installation of SQL Feature and SharePoint:
Here, we need to consider two things to get the Reporting services feature
Install SharePoint First and then the Reporting services feature, Then You can see the Reporting Service Application Under Application management->service Applications
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
http://1.bp.blogspot.com/-5L8E2_I3fg8/UzOeSWA0o4I/AAAAAAAABtk/NCOzEJq3WSw/s1600/10.bmp
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.
http://3.bp.blogspot.com/-MEpzS72u-0M/UzOeje3dOtI/AAAAAAAABtw/2oKWwJRGO9A/s1600/8.bmp
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.
http://4.bp.blogspot.com/-2yz0Meujrg4/UzOejCswaFI/AAAAAAAABts/6kNc9jby2ng/s1600/9.bmp
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.
Note: I resolved the issue by above Method. If you find a different solution, please report it as a comment to this post. This will be useful to SharePoint Community. Be sure to double-verify it: undo your solution and verify that the problem comes back, then redo it and verify that the problem goes away.