Microsoft Office Tutorials and References
In Depth Information
Choosing the Right SSRS Mode
SSRS operates in two modes, native and SharePoint mode. With native mode, Report Server takes the lead and
manages all the functions of reporting services. If there is no plan for implementing SharePoint or for integrating with
SharePoint, then choosing native mode is appropriate. However, there are significant advantages to using SharePoint
mode. Here are some of them.
Familiar user interface with consistent look and feel
Document libraries to host reports and data sources
Single security model for all reports since they are deployed as items in a document library
BI dashboards designed with reports
SharePoint features for collaboration
Publishing and subscription of reports
Delivery of reports in chosen formats
Use SharePoint scability options for SSRS reports
Reporting Services supports multiple instances of Report Server and you can have both modes running on
a single server. However, to integrate with SharePoint, additional configuration steps are needed. And it is also
important to understand what changes occur to the infrastructure after installing SSRS and integrating with
SharePoint. Since the SharePoint platform provides the necessary infrastructure when you choose SharePoint mode,
you no longer have the functions such as Report Manager, Management Studio, My Reports, Linked Reports, and Job
Management that are available in native mode. Also, there’s no way to migrate reports deployed in native mode to
SharePoint mode. You have to republish them to SharePoint manually.
Installing and setting up SQL Server Reporting Services and SharePoint 2013 is quite easy. Though you can
choose to install any edition of SQL Server 2012, in this chapter we will walk you through installing and configuring
Enterprise edition for SharePoint mode.
■ to understand the differences in the feature set of various SQL Server 2012 editions, see the reporting
Services Section at http://msdn.microsoft.com/en-us/library/cc645993(v=SQL.110).aspx .
Setting Up the Infrastructure
After you’ve finished the basic steps for installing SQL Server, such as verification, entering the product key, accepting
licensing terms, and installing setup support files, you can then choose features as shown in Figure 3-2 . If you are
installing SQL Server for the first time, you can select Reporting Services, along with Database Engine Services and
others features. If SQL Server is already installed and you are setting up Reporting Services now, rerun the SQL Server
setup and choose Reporting Services in the Features pane.
Search JabSto ::