Microsoft® SQL Server® 2012 Bible

1261

CHAPTER

56

Confi guring and Administering

Reporting Services

IN THIS CHAPTER

Deploying Reports

Understanding the Security Model and Guidelines

Confi guring a General Server

Using Data-driven Subscriptions

Exploring Features Available Through SharePoint Integrated Mode

A good administrator keeps an organization’s reports secure, highly available, and easily recovered

from disasters. Many decisions and skills are required to do this for Reporting Services, many of

which are new with the changes in this new release. This chapter covers the essentials to keep your

reports safe and performing well.

Installing Reporting Services

A primary component of a Reporting Services solution happens at the initial installation. This has

never been truer than with this release, with the rapidly expanding suite of features available

through SharePoint integrated mode. Although using Reporting Services in native mode still deliv-

ers a sophisticated set of functionality, the focus of the latest edition of SQL Server adds many new

features to SharePoint integrated installations.

Native Mode

A Reporting Services native mode instance can run on the same hardware as the relational database

but doesn’t need to if the system load requires scale-out. For more information on scale-out report-

ing solutions, see http://sqlcat.com/sqlcat/b/technicalnotes/archive/2008/06/05/

reporting-services-scale-out-architecture.aspx. Installing the server in native mode

creates one Windows service and installs two relational databases: one that contains deployed

c56.indd 1261c56.indd 1261 7/31/2012 10:34:13 AM7/31/2012 10:34:13 AM

http://www.it-ebooks.info