Skip to Main Content
Professional Microsoft® SQL Server® 2008 Reporting Services
book

Professional Microsoft® SQL Server® 2008 Reporting Services

by Paul Turley, Thiago Silva, Bryan C. Smith, Ken Withee
December 2008
Beginner to intermediate content levelBeginner to intermediate
815 pages
20h 1m
English
Wrox
Content preview from Professional Microsoft® SQL Server® 2008 Reporting Services

Chapter 14. Report Server Administration

To ensure the integrity and reliability of your Reporting Services environment, it is important that you develop a comprehensive administrative plan for it. This plan should address the following general concerns:

  • Security

  • Backup and recovery

  • Monitoring

  • Configuration

In this chapter, you will explore these topics as they relate to Reporting Services. This will provide you the basic knowledge you will need to then engage users, developers, and IT administrators in the development of a plan tailored to the specific needs of your organization.

Security

Properly securing your Reporting Services environment requires you to find the right balance between risk, availability, and supportability. Following good network, system, and facilities management practices goes a long way toward securing your installation. Specific to Reporting Services, you should consider how to best approach:

  • Account management

  • System-level roles

  • Surface area management

Account Management

Reporting Services must interact with various resources. To access these resources, Reporting Services must present its requests as originating from a specific, valid user. Reporting Services stores credentials, typically username and password combinations, for the following three accounts, each of which is used to handle specific interactions with resources:

  • The service account

  • The application database account

  • The unattended execution account

Whenever possible, it is recommended that you make use of Windows ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft® SQL Server® 2008 Reporting Services Step by Step

Microsoft® SQL Server® 2008 Reporting Services Step by Step

Stacia Misner
Beginning, Microsoft® SQL Server® 2008 Administration

Beginning, Microsoft® SQL Server® 2008 Administration

Chris Leiter, Dan Wood, Albert Boettger, Michael Cierkowski
Professional SQL Server™ 2005 Integration Services

Professional SQL Server™ 2005 Integration Services

Brian Knight, Allan Mitchell, Darren Green, Douglas Hinson, Kathi Kellenberger, Andy Leonard, Erik Veerman, Jason Gerard, Haidong Ji, Mike Murphy

Publisher Resources

ISBN: 9780470242018Purchase book