Microsoft SQL Server 2014: Manage Reporting Services

Microsoft SQL Server 2014: Manage Reporting Services

Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level

Overview/Description
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

Prerequisites
None

Expected Duration (hours)
1.6

Lesson Objectives

Microsoft SQL Server 2014: Manage Reporting Services

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

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