Security is hard, but that is not a good reason to do things the easy way. A big challenge for SQL Server DBAs is configuring security for SSRS when faced with the "double-hop" issue. The way to solve this problem is by implementing Kerberos delegation. This course will explain what Kerberos is and why you need it. More importantly, it will provide the knowledge required to configure it and troubleshoot when things go wrong.
Kathi Kellenberger is a SQL Server MVP and a Teammate with Linchpin People. She is the author or co-author of several SQL Server books, including Beginning T-SQL from Apress, and frequently speaks at community events such as PASS Summit and SQL Saturday.
Hi everyone, my name is Kathi Kellenberger and welcome to my course Configuring Kerberos for SSRS I am an independent database consultant at Linchpin People. When Kerberos delegation is not configured, SSRS cannot pass the user’s credentials to SQL Server, and the connection fails. This is called the double-hop issue. This course will teach you why Kerberos delegation is so important, how to configure it, and troubleshoot the issuesSome of the things we will cover include: 1. Configuring Kerberos for SSRS in native mode. 2. Configuring Kerberos for SharePoint integrated mode. 3. AND Working with managed service accounts. By the end of this course, you’ll understand how Kerberos works and you’ll know where to look to troubleshoot when things go wrong.Before beginning the course you should be familiar with managing SQL Server and Reporting Services. I hope you’ll join me on this journey to learn about Kerberos Delegation with the Configuring Kerberos for SSRS course, at Pluralsight.