Contents
In SharePoint Integrated mode, when a user makes a request for a particular report, the Report Server Proxy Endpoint will take care of the report processing from SharePoint along with Report Services to return the rendered result. For configuring the Report Server, go to the Reporting Services Configuration from the Start menu (see image below).
Supported combinations Number Report server Add-in SharePoint version 1 SQL Server 2016 SQL Server 2016 SharePoint 2016 2 SQL Server 2016 SQL Server 2016 SharePoint 2013 3 SQL Server 2014 SQL Server 2014 SharePoint 2013 4 SQL Server 2014 SQL Server 2014 SharePoint 2010
How does SQL Server Reporting Services work in SharePoint?
SQL Server Reporting Services in SharePoint, enables report creation and viewing in document libraries, Reporting Services subscription delivery of reports through email, Power View, data alerting, and report management features, all in a deployment of based of Microsoft SharePoint.
How does SSRs work with SharePoint integration mode?
SSRS architecture in Native Mode and in SharePoint integration Mode. The SQL Servers Reporting Services architecture have mainly 3 parts /layers The Data layer consists of the Base Data Sources like data warehouse / transactional DB / Analysis Services Cube , Report Server Databases etc.
SharePoint mode supports SharePoint Server 2016 backup and restore for SQL Server Reporting Services service application and Unified Logging Service (ULS) trace logs. SharePoint mode also supports claims-based authentication. SharePoint mode requires that a report server component of Reporting Services must run within a SharePoint Server farm.
Before configuring the Report Server in SharePoint Integration Mode ,let’s make sure that server is installed with the Report Services Add – in (on the SharePoint Server) and SQL Server SP2 (on database the server). In SharePoint Integrated mode, the architecture is a little different from Native mode.