Overview of SQL Server Reporting Services 2012 Architecture, Features, and Tools - Learning SQL Server Reporting Services 2012 - page 125

SQL Server 2012

Reporting Services
Native Mode

IE
Browser.

Reportting Services
SharePoint Integrated Mode

SSDT BISM

RS_Add-IN

SharePoint 2010

Analysis Services Server

HI SQL Server 2012

NJ

ReportServer$HI
ReportServer$HITempDB

ReportingService_b67933dba1f14282bdf434479cbc8f8f-->Power ViewReports&.rsds
ReportingService_b67933dba1f14282bdf434479cbc8f8f_Alerting
ReportingService_b67933dba1f14282bdf434479cbc8f8fTempDB

Report Server

SQL Server Agent

SQL Server Agent

Jobs
Security-->Roles/System Roles
Shared Schedules

Primarily, SQL Server 2012 Enterprise Edition is used as described in Chapter 1 ,
Overview and Installation - SQL Server Reporting Services 2012 , for both Native mode
as well as SharePoint Integrated mode. As we see in the previous diagram, Report
Server Native mode is on a named instance HI (in some places another named
instance Kailua is also used). This server has the Reporting Services databases
ReportServer$HI and ReportServer$HITempDB . The associated Report Server
handles Jobs, Security, and Shared Schedules. The Native mode architecture
described in the next section is taken from the Microsoft documentation. The tools
(SSDT, Report Builder, Report Server Configuration, and so on) connect to the
Report Server. The associated SQL Server Agent takes care of the jobs such as
subscriptions related to Native mode.

The SharePoint Server 2010 is a required element with which the Reporting
Services add-in helps to create a Reporting Services Service. With the creation of
the RS Service in SharePoint, three SQL Server 2012 databases (shown alongside
in the diagram) are created in an instance with its Reporting Services installed in
SharePoint Integrated mode. The SQL Server 2012 instance NJ is installed in this
fashion. These databases are repositories for report content including those related
to Power Views and Data Alerts.

The data sources (extension .rsds ) used in creating Power View reports (extension .
rdlx ) are stored in the ReportingService_b67933dba1f14282bdf434479cbc8f8f
database and the alerting related information is stored in the ReportingService_
b67933dba1f14282bdf434479cbc8f8f_Alerting database. Not shown is an Express
database that is used by the SharePoint Server for its content, administration, and so
on. As described in Chapter 1 , Overview and Installation - SQL Server Reporting Services
2012 , RS_ADD-IN allows you to create the service. You will use the Power Shell tool
to create and manage the service.