Chapter 22

SQL Server Reporting Services Administration


  • How to Use SQL Server Configuration Manager to Set Up Your Newly Installed SQL Server Reporting Services Server
  • Navigating and Understanding the Properties Associated with an Installed Reporting Services Server
  • Using Report Builder to Create New Reports Useful to the DBA
  • Managing and Executing Reports with Report Manager

SQL Server Reporting Services (SSRS) is one of the simplest tools in the Microsoft stack to configure. This is because of the easy-to-use SQL Server Configuration Manager and the complete, yet understandable, properties of a Reporting Services server, accessed through SQL Server Management Studio. To understand how Reporting Services works, you need to understand how a report is built and executed. Thus a brief overview of Report Builder is in order, and you can even use it to create reports useful to DBAs. Then the real fun begins, as you see Reporting Services in action through the use of Report Manager. Report Manager is a suite of web pages that ships with SSRS. These pages enable users to easily execute their reports and give administrators methods to manage, schedule, and maximize server resources.


Reporting Services is configured using its own tool, separate from the SQL Server Configuration Manager. In most cases you’ll have already configured your instance of Reporting Services during the install of SQL Server. Following ...

Get Professional Microsoft SQL Server 2012 Administration now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.