1262
Part IX: Business Intelligence
report defi nitions and other metadata, and a second for temporary objects used in process-
ing. After installation, be sure to visit the Reporting Services Confi guration Manager to
adjust settings, back up the encryption keys, and save them in a safe place. Keeping all
the metadata in the ReportServer database makes it simple to back up, but without the
encryption key a restore is diffi cult.If you have chosen native mode in the installation program of SQL Server, you should
choose a service account under which Reporting Services will run. You also should install
the following shared features:■ (^) SQL Server Data Tools: Gives you the Report Designer, the Visual Studio tool used
to develop reporting project objects
■ (^) Client Tools connectivity: Gives you access to OLE DB and ODBC connections
■ The Management Tools: Provides you with SQL Server Management Studio, which
provides administrative tools for Reporting Services
During installation you will also be prompted to choose the Service Account under which
Reporting Services runs. Which account and what type of account (local, domain, separate
accounts, same account for all SQL Server Services, and so on) depends greatly on whether
the server is a development machine, production, or part of a scale out deployment. For guid-
ance in selecting the best account to use, see Confi guring the Report Server Service Account
at http://msdn.microsoft.com/en-us/library/ms160340(v=SQL.110).aspx.
SharePoint Integrated Mode
The other option for hosting your reports is SharePoint integrated mode.
Previous to SQL Server 2012, Reporting Services Integration to SharePoint had been
complex to confi gure, requiring the skillsets of both a database administrator and a
SharePoint administrator. Now all confi guration options for Reporting Services are
available from the Central Administration page of SharePoint. All that is required from
the SQL Server install is to click the radio buttons under Shared Services: Reporting
Service - SharePoint and Reporting Services Add-In for SharePoint Products, as shown
in Figure 56-1.
Some other improvements offered with 2012 integrated mode include the following:
■ (^) Reporting Services uses SharePoint’s built-in scale and load balancer.
■ The Reporting Services catalog is a SharePoint Service Database.
■ (^) Data Alerts are available for confi guration. A user can confi gure e-mails to be sent
when certain criteria are met in a report.
■ (^) SharePoint cross-farm access: If the farm is trusted, users on one farm can consume
reports on the other.
■ (^) Ability to back up and restore Reporting Services catalog from inside Central Admin UI.
c56.indd 1262c56.indd 1262 7/31/2012 10:34:16 AM7/31/2012 10:34:16 AM
http://www.it-ebooks.info