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