question

polar-0609 avatar image
0 Votes"
polar-0609 asked polar-0609 commented

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

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!

azure-ad-authenticationdotnet-aspnet-core-mvcazure-ad-app-registrationazure-ad-app-management
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

cthivierge avatar image
0 Votes"
cthivierge answered polar-0609 commented

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

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

hth

· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks for your help. Unfortunately, my clients do not want to pay to upgrade their AAD tier. I am using free Azure AD level

0 Votes 0 ·

And if you build your own ADFS/WAP farm ?
You could publish the SSRS through the WAP... i think it could work

https://social.msdn.microsoft.com/Forums/azure/en-US/a0c83b0d-964f-4ca6-9ce4-dde909eb6003/authenticating-ssrs-using-azure-ad-federating-onpremise-ad?forum=WindowsAzureAD

hth

0 Votes 0 ·

Thanks for your help! We have decided to secure the data using the azure identity parameter in the reports' datasets

0 Votes 0 ·