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

Question

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?

Answer 1

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://learn.microsoft.com/en-us/power-bi/consumer/mobile/mobile-oauth-ssrs#active-directory-federation-services-adfs-configuration

https://learn.microsoft.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