Securing SSRS Reporting Solutions
SSRS uses a role-based security architecture for administrative tasks and access to items published to the report server. This course will teach you how to use all SSRS security features for a native mode report server.
What you'll learn
After you install an SSRS instance on a server, you need to configure security so that authorized users can perform tasks and view content. In this course, Securing SSRS Reporting Solutions, you’ll learn about report server configuration options and how to secure report server content. First, you’ll explore your options for setting up the report server for access by administrators, report developers and publishers, and report consumers. Next, you’ll discover how to work with role assignments to manage the content that each type of user can view and the activities they can perform. Finally, you’ll learn how to manage security for data sources used to retrieve data for reports during processing. When you’re finished with this course, you’ll have the skills and knowledge of SSRS security configuration to successfully secure the reporting environment for your organization.
Table of contents
- Configuring Report Server Security 2m
- SSRS Environment 4m
- Security Goals 5m
- Server Authentication Options 2m
- User Accounts and Groups 2m
- SSRS Service Account 4m
- SSRS Database Connection 5m
- SMTP Server Permissions 5m
- Execution Account 2m
- Subscription File Share 2m
- Ports 2m
- NTLM vs. Kerberos 1m
- NTLM Behavior 3m
- Kerberos Configuration 4m
- Basic and Custom Authentication 3m
- Surface Area Reduction 2m
- Summary 2m
About the author
Stacia Misner Varga is an instructor, author, and principal consultant of Data Inspirations. Her career spans more than 30 years, with a focus on improving business practices through technology. Since 2000, she has provided consulting and education services for Microsoft’s data platform and authored or co-authored many books covering this topic. In addition, Stacia has been a frequent speaker over the years at technology conferences worldwide.