setup SSO for SSRS 2019 WEB PORTAL

Question

Hi team,

This is Ranger , our team is on a project migrating SSRS 2012 Sharepoint mode to SSRS 2019 Native mode. And our customer wants us access SSRS 2019 web portal using SSO.
In our customer's network, every user has a global id, with which user can log in all other applications with SSO. Now SSRS 2019 web portal is required to be included.

As I know that SSRS doesn't support SSO as default. SSRS doesn't support SAML either.
And there's no AD FS servers in customer system, so enabling SSO using WAP + AD FS server is not working.

SO here for help on what approaches do we have to setup SSO for SSRS?
We are not going to do lots of coding to support this. It's better to do configurations other than code developing.
Looking forwards to your reply and help.

Answer 1

Hi @Chai, Ranger Ruiguang
To setup SSO for SSRS, you have to custom security extension.
You can see:
https://learn.microsoft.com/en-gb/archive/blogs/cliffgreen/reporting-services-single-sign-on-sso-authentication-part-1
https://learn.microsoft.com/en-gb/archive/blogs/cliffgreen/reporting-services-single-sign-on-sso-authentication-part-2

This is also an example of how to implement SAML 2.0 response-based SSO authentication in SSRS:
https://www.mssqltips.com/sqlservertip/4988/sql-server-reporting-services-custom-security-with-single-signon/

Best regards,
Aniya