question

gelog avatar image
0 Votes"
gelog asked LukasYu-msft commented

Kerberos Delegation for SSRS

Hi,

I have a web application that authenticates using Azure AD. Within that web application, I need to access reports from an SSRS server. I have found that this is possible through Kerberos Constrained Delegation. I have found a few articles showing how it can be achieved but I am not all too sure which one would best work for my scenario.

Link 1: https://docs.microsoft.com/en-us/azure/active-directory/app-proxy/application-proxy-configure-single-sign-on-with-kcd
Link 2: https://docs.microsoft.com/en-us/azure/active-directory/app-proxy/application-proxy-integrate-with-power-bi
Link 3: https://docs.microsoft.com/en-us/power-bi/consumer/mobile/mobile-oauth-ssrs

Looking for any ideas that would help my case.

Thank you!

azure-active-directorysql-server-reporting-services
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.

MarileeTurscak-MSFT avatar image
0 Votes"
MarileeTurscak-MSFT answered

Currently SSRS does not have cloud version, so you could only use a VM on Azure to host the SSRS server. In that case you could deploy SSRS to a VM and use Azure SQL Database as the data source., and then connect to your web app. https://web.archive.org/web/20140523110804/http://msdn.microsoft.com/en-us/library/azure/jj992719.aspx

You could also migrate SSRS to the new Power BI Report Server (the replacement for SSRS) and then integrate it with your web app. https://docs.microsoft.com/en-us/power-bi/report-server/azure-application-proxy


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.

LukasYu-msft avatar image
0 Votes"
LukasYu-msft answered LukasYu-msft commented

Hi,

Though I am not very familiar with Azure Application Proxy, at first glance, I think Link 2 and Link 3 is more related with Power BI mobil apps. The article from Link 1, among the three articles, it is more suit for your scene and your demand.

Regards,
Lukas

· 1
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.

Did you resolve the issue ? Any updates on this is appreciated.

0 Votes 0 ·