Integrate On-Premises ADFS 3.0 with Microsoft SQL Server 2017 Reporting Services

kescott 21 Reputation points
2020-12-02T16:38:56.717+00:00

I have setup a SQL Server 2017 and SSRS 2017 on my on premise server. I am able to login via windows authentication and create SSRS 2017 reports.
I am trying to provide SSRS 2017 reporting services capabilities to my customer. I am only allowed to use ADFS 3.0 (Windows 2016) authentication.

Are there any referenced resources that provide detailed steps on how to get this done?

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,940 questions
Active Directory Federation Services
Active Directory Federation Services
An Active Directory technology that provides single-sign-on functionality by securely sharing digital identity and entitlement rights across security and enterprise boundaries.
1,264 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 37,671 Reputation points
    2020-12-03T03:10:43.013+00:00

    Hi @kescott ,

    Below links are both centered around using OAuth in mobile apps, but it should give you pointers on how to configure SSRS to use ADFS for authenticating users.

    https://video2.skills-academy.com/en-us/power-bi/consumer/mobile/mobile-oauth-ssrs#active-directory-federation-services-adfs-configuration

    https://video2.skills-academy.com/en-us/archive/blogs/sqlrsteamblog/leveraging-web-application-proxy-in-windows-server-2016-to-provide-secure-access-to-your-sql-server-reporting-services-environment

    Some other related articles for your reference:

    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/36d6d0de-0576-4242-97a8-44820af5c043/adfs-20-and-ssrs?forum=sqlreportingservices

    Regards，

    Zoe

    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    Hot issues October

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.