O'Reilly logo

Professional Microsoft SQL Server 2012 Administration by Ross LoForte, Steven Wort, Adam Jorgensen, Brian Knight

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 22

SQL Server Reporting Services Administration

WHAT’S IN THIS CHAPTER?

  • 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.

SQL SERVER REPORTING SERVICES CONFIGURATION MANAGER

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required