Maintaining SQL Server 2008 Reporting Services

This course is included in our On-demand training solution.


Administration and maintenance of Microsoft SQL Server 2008 Reporting Services and its components is key in providing customers and clients access to the Business Intelligence information they need. This course outlines the tools used and tasks involved in managing and maintaining access to Reporting Services and corresponding data. It covers the authentication subsystem and role-based authorization model used by Reporting Services, as well as the configuration of system-level and item-level role-based security. SQL Server 2008 also provides the ability to deploy and manage the report server and content using the Report Server Web Service and command-line tools. This course describes how to use these tools to automate administrative tasks and manage reports remotely through the web interface. It also outlines the options for monitoring server performance, report activities, and statistics using performance counters and the use of log files in evaluating server status and performance. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft exam: 70-448 TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance. Passing this exam will earn the learner Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Business Intelligence Development and Maintenance certification.

Target Audience

IT professionals working to develop and maintain Microsoft SQL Server 2008 business intelligence solutions or those pursuing a career as a database administrator or developer


Familiarity with Microsoft .NET Framework; experience with SQL Server 2005 or SQL Server 2008 business intelligence components; experience in performing queries on relational databases and using SQL Server Management Studio and Business Intelligence Development Studio

Expected Duration

90 min.

Course Objectives

Administering and Managing SSRS

  • recognize how to configure SSRS
  • recognize how to perform administration and maintenance of SSRS
  • Implementing SSRS Security

  • recognize the features of SSRS Security
  • recognize how to create a new role
  • Automating SSRS Administration

  • recognize how to automate SSRS administration
  • Performing SSRS Management Tasks

    Maintaining SSRS Performance

  • recognize how to monitor and maintain SSRS performance