Managing Reporting Services

SQL Server 2014    |    Expert
  • 14 Videos | 1h 20m 55s
  • Earns a Badge
Likes 23 Likes 23
For optimal performance and security, you must maintain and monitor SQL Server Reporting Services. Learn how to manage the Report Server, including troubleshooting, and performance tuning, and how to configure security.

WHAT YOU WILL LEARN

  • 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
    view Reporting Services log files
    monitor Reporting Services with SQL Profiler
    use Windows Reliability and Performance Monitor to monitor a report server

IN THIS COURSE

  • Playable
    1. 
    Understanding Report Server Security Architecture
    5m 58s
    UP NEXT
  • Playable
    2. 
    Configuring Report Server Level Security
    4m 49s
  • Locked
    3. 
    Configuring Item Level Security
    6m 17s
  • Locked
    4. 
    Securing Reports Using Roles
    4m 7s
  • Locked
    5. 
    Securing Shared Data Source Items
    5m 36s
  • Locked
    6. 
    Configuring Stored Credentials
    5m 30s
  • Locked
    7. 
    Configuring SharePoint Groups and Permissions
    7m 37s
  • Locked
    8. 
    Managing Encryption Keys
    4m 54s
  • Locked
    9. 
    Creating and Adding Snapshots
    5m 57s
  • Locked
    10. 
    Creating a Report History
    4m 23s
  • Locked
    11. 
    Managing a Reporting Services Database
    6m 57s
  • Locked
    12. 
    Viewing Report Services Log Files
    5m 54s
  • Locked
    13. 
    Monitoring Reporting Services with SQL Profiler
    5m 47s
  • Locked
    14. 
    Using Reliability and Performance Monitor
    7m 10s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 498 Likes 498  
Likes 110 Likes 110  
Likes 29 Likes 29