Microsoft SQL Server 2014: Manage Reporting Services

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
97 minutes

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.


Security Configuration

  • start the course
  • describe Report Server security architecture and site-level security
  • create server-level roles and assign users to the roles to allow report server access
  • create item-level roles to grant permissions to users
  • secure a report using different types of roles
  • secure a shared data source
  • configure stored credentials to allow access to external data for a report
  • configure SharePoint groups and permissions for access to Report Server item
  • manage encryption keys for Reporting Services

Manage a Report Environment

  • create snapshots and add them to report history
  • create a report history
  • manage a reporting services database, including backup and restore, copying, and managing connections
  • view Reporting Services log files
  • monitor Reporting Services with SQL Profiler
  • use Windows Reliability and Performance Monitor to monitor a report server

Practice: Manage Reporting Services

  • configure security and manage the Report Server





Multi-license discounts available for Annual and Monthly subscriptions.