Microsoft SQL Server 2014: Manage Reporting Services

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


An important administration task for SQL Server Reporting Services is to ensure that users can only access reports and parts of the reports that they require. Security for Reporting Services can be implemented at various levels, from the server down to specific items in a report. Administrators also have to manage the Report Server for performance and availability. This course will demonstrate how to configure security for reports and manage the Report Server, including backing up and restoring, troubleshooting, and performance tuning. This course is one in a series of Skillsoft courses to help prepare for the 70-466 Implementing Data Models and Reports with Microsoft SQL Server certification exam.

Target Audience

Business intelligence developers who create reporting and analysis solutions, and individuals interested in taking the Implementing Data Models and Reports with Microsoft SQL Server certification exam



Expected Duration

90 min.

Course Objectives

Course Introduction

Understanding Report Server Security Architecture

  • describe Report Server security architecture and site-level security
  • Configuring Report Server Level Security

  • create server-level roles and assign users to the roles to allow report server access
  • Configuring Item-level Security

  • create item-level roles to grant permissions to users
  • Securing Reports Using Roles

  • secure a report using different types of roles
  • Securing Shared Data Source Items

  • secure a shared data source
  • Configuring Stored Credentials

  • configure stored credentials to allow access to external data for a report
  • Configuring SharePoint Groups and Permissions

  • configure SharePoint groups and permissions for access to Report Server item
  • Managing Encryption Keys

  • manage encryption keys for Reporting Services
  • Creating and Adding Snapshots

  • create snapshots and add them to report history
  • Creating a Report History

  • create a report history
  • Managing a Reporting Services Database

  • manage a reporting services database, including backup and restore, copying, and managing connections
  • Viewing Report Services Log Files

  • view Reporting Services log files
  • Monitoring Reporting Services with SQL Profiler

  • monitor Reporting Services with SQL Profiler
  • Using Reliability and Performance Monitor

  • use Windows Reliability and Performance Monitor to monitor a report server
  • Exercise: Managing Security and the SSRS Server