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