How to connect to SSRS reports from ASP.NET reportviewer using Azure AD credentials, not integrated mode credentials

polar 1 Reputation point
2021-09-09T13:37:13.453+00:00

Greetings,

I have a .net MVC web app on premises that authenticates users by obtaining tokens from the Azure AD, synchronized with the active directory on premises. Upon accessing the app, the user can click on page links to render on-premises SSRS reports. The Azure AD identity is passed into the SSRS reports as a reportviewer parameter to be used with the reports' datasets.

Everything works fine except the .net page connects to the Reporting Services using network credentials, not Azure credentials. Is there any way to pass User.Identity.Name as a login to connect to the SSRS?

Thanks!

ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
4,308 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
20,182 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. cthivierge 4,056 Reputation points
    2021-09-09T14:42:58.947+00:00

    I'm not sure it's possible without using a Web Application Proxy or Azure Application Proxy

    This may help
    https://learn.microsoft.com/en-us/answers/questions/296936/ssrs-2016-single-sign-on-with-azure-ad.html

    hth