Introduction
SSRS (SQL Server Reporting Services) is a tool that help us
to create, deploy and manage reports. It supports variety of data sources. SSRS
can be installed in two modes viz. Native mode & Integrated mode and can be
used in either of two modes. In this articles, I will walk you through SSRS
installation in integrated mode and its integration with SharePoint 2013.
Software
Requirements
·
SQL Server 2012 R2/2014 Enterprise Edition
·
SharePoint 2013
·
MS SQL Server 2012/2014 Add-in for SharePoint 2013
It will be a standalone server architecture, where all
required softwares will be installed on single server. However we can extend it
to multiple server. Just to keep the things easy, I will explain the Single
Server Architecture.
Implementation Steps
Step 1: Install SQL Server
Reporting Services and SQL Server Database Engine:
Run the SQL Server Installation Wizard to install SQL
server. While doing the installation, it
will ask for feature selection where you can specify the features which are required
to be installed.
On the Reporting Services
Configuration page
you should see the Install only option is selected. This option installs
the report server files, and does not configure the SharePoint environment for
Reporting Services.
Step 2: Install MS SQL 2014
Reporting Services Add in for SharePoint 2013
If the MS SQL 2014 Reporting Services
Add in for SharePoint 2013 is not installed during SQL Server 2014
installation, please download and install it from this link.
The SQL Server 2014 Reporting Services Add-in for Microsoft SharePoint
technologies allows you to integrate Reporting Services features with the
collaborative SharePoint experience.
Step 3: Install and
Configure SharePoint 2013
Run the setup of SharePoint to start installation. While
configuring a SharePoint farm, specify the System Account (domain account) as a
farm admin. Configure the SharePoint server to use above installed instance of
SQL server 2014.
Step 4: Activate Reporting Services feature
a. Open Central
Administration.
b. Go to Site Settings
c. Under Site Collection administrator,
click Site collection Features
d. Activate Report Server Central Administration
feature
e. Activate Report Server Integration feature.
Step 5: Register and Start
Reporting Services SharePoint Service
The following are the common reasons why you need to
manually register the Reporting Services service.
You
installed Reporting Services SharePoint mode before SharePoint was installed. The
account used to install Reporting Services SharePoint mode, was not a member of
the SharePoint farm administrators group. The necessary files were installed as part of the SQL Server
installation wizard, but the services need to be registered into the SharePoint
farm. The SQL Server 2014 release introduces PowerShell support for Reporting
Services in SharePoint mode.
Open the SharePoint PowerShell and run following commands:
Install-SPRSService
Install-SPRSServiceProxy
Step 6: Create SSRS Service
Application
Below are the steps to create a service application and a
description of the properties:
1. In SharePoint Central Administration, in the Application Management group,
click Manage Service
Applications.
2. In the SharePoint ribbon, click the new button.
3. In the New menu, click SQL Server
Reporting Services Service Application.
Fill in the necessary details and the Service Application
is ready to be used.
Step 7: Create BI site and
Configure Document library for Reports
Create a new BI site from Central Admin by selecting Business
Intelligence template in Enterprise section. Create a document library and add
below three content types:
·
Report Builder
·
Report Model
·
Report Data Source
Step 8: Upload Reports and
attach Data Source
You can create SSRS reports using SSDT or Visual Studio or SSRS Report
Builder tool. Upload the .rdl (Report Definition Language) files and .rsds(Report
Server data Source) files in document library. Attach the .rsds file to .rdl
file by selecting manage data source.
That’s it guy’s, we have successfully integrated SSRS with SharePoint
2013. Click on any rdl file, it will
redirect you to a report UI.
Summary
I walked you through the integration of SSRS with SharePoint
2013. I faced some issues while doing it but by following these steps you will
not get any issues. If you face any problem while doing, you can contact me J
Happy reading. Have a great day ahead
You can write your feedback in comments below that will help
me in improving myself. Thanks! Cheers J
No comments:
Post a Comment