How do I enable sso for SSRS in azure

Roop Gajjar 20 Reputation points
2024-01-18T07:01:15.3166667+00:00

Hi. My customer is migrating their application from a datacenter to Azure. The work has been done now but they have implemented SSRS. However would like it to be Single Sign on using azure AD.
I have read that SSO doesn’t work in SSRS but wonder if it could work if I register with App registration in entra ID. Any advice would be appreciated. Regards roop

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,993 questions
0 comments No comments
{count} votes

Accepted answer
  1. Azar 26,185 Reputation points MVP
    2024-01-18T07:10:05.6533333+00:00

    Hi
    Roop Gajjar
    To set up 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/

    If this helps kindly accept the answer thanks much.


0 additional answers

Sort by: Most helpful

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.