Database Reference
In-Depth Information
rePorTIng serVICes serVer suPPorTs mulTIPle InsTAnCes
It is important to understand that a given Reporting Services report server,
like the database engine, can support multiple instances. You can configure
each instance of Reporting Services in either native or SharePoint Integrated
Mode, but after you select the mode it is very difficult to change it (for
details on how to switch server modes, please see the Microsoft MSDN
article “Switch Server Modes” at
http://msdn.microsoft.com/en-us/
library/bb326407.aspx
).
To support multiple Reporting Services instances you need to create a new
database, and only one instance can be associated with SharePoint. In the
SQL Server 2012 release, more than one Reporting Services instance can
be associated with SharePoint.
NATIVE MoDE
Reporting Services has a Native mode that enables both users and adminis-
trators to access reports using a Report Manager web application. The Native
mode provides a report server that is a standalone application providing
report viewing, management, administration, processing, and delivery. The
Native mode provides a complete self-service approach to report browsing
and access, but it's not without its limitations.
The original Report Manager web application was intended to be used as
a sample application to aid in the design and development of custom web
applications that would use the Reporting Services application programming
interfaces (APIs) demonstrated within Report Manger. Many people feel that
Report Manager provides a quick solution for handling basic reporting needs,
but that it offers very little opportunity to customize the management and
delivery of reporting.
When configured in Native mode, you can view reports on SharePoint websites
using SharePoint web parts, but there are no management capabilities pro-
vided via these web parts and they cannot be connected to other SharePoint
web parts.
SHArEPoINT INTEGrATED MoDE
SharePoint Integrated Mode enables users and administrators to access the
Reporting Service report server using the SharePoint server. This mode offers
