Sharepoint ADFS with SSRS report

Question

Sharepoint ADFS with SSRS report

Frank LOH 21

I have :

1) A Sharepoint 2013 server running on Windows Server 2012 R2 Standard. SSRS reporting 12 (12.0.5000.0) is installed here in Native mode. Currently the SSRS report uses http, if that makes any difference.

2) An ADFS server running Windows Server 2019 Standard. Not sure how to check the ADFS version.

I can reach Sharepoint via ADFS authentication. Currently SSRS reporting is only reachable from within the SP/SSRS server itself. I want it reachable from Sharepoint with ADFS. Is it possible to have SSRS in Native mode or must it be in Integrated mode? How do i get user to be able to authenticate to SSRS?

Pierre Audonnet - MSFT 10,191 Reputation points Microsoft Employee

2021-04-28T19:14:23.027+00:00

I added a Sharepoint tag. I left the adfs tag, but that's not really in scope here as it seems (at least so far) to be very Sharepoint specific.

1 answer

Your answer

Pierre Audonnet - MSFT 10,191 Reputation points Microsoft Employee

2021-04-28T19:14:23.027+00:00

I added a Sharepoint tag. I left the adfs tag, but that's not really in scope here as it seems (at least so far) to be very Sharepoint specific.

Answer 1

Echo Du_MSFT 17,316

Hello @Frank LOH ,

According to my understanding of your question, you want to use ADFS in Windows Server 2019 Standard to access SSRS(SQL Server Reporting Service) in Windows Server 2012 R2 Standard.

Based on my research, due to version reasons, this is impossible to achieve.

SSRS reporting 12 (12.0.5000.0): The SQL Server 2014 SP2 Reporting Services

The following SQL server versions are supported with AD FS in Windows Server 2012 R2:

SQL Server 2008 / R2
SQL Server 2012
SQL Server 2014

However, in Windows Server 2019, your need Microsoft SQL Server 2019 Reporting Services(15.0.1102.896).

Thanks,
Echo Du

=============================

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Frank LOH 21 Reputation points

2021-04-29T09:14:11.747+00:00
@Echo Du_MSFT thanks for the reply. I would like to clarify things as I"m not familiar with this ADFS thing. This is the sequence of login for the users.

User goes to the Sharepoint site federated with ADFS

User redirected to ADFS for authentication

Once authenticated, user gets redirected to Sharepoint site.

Now user is already in Sharepoint and we have a menu to connect to the SSRS web service URL which is hosted in the same server itself. However user is prompted with a login prompt but user doesn't have the right credential to log in, as the user was authenticated through ADFS before being redirected to Sharepoint.
Echo Du_MSFT 17,316 Reputation points

2021-04-29T10:13:43.527+00:00

Hi @Frank LOH ,

Thanks for your reply.

Can you provide detailed screenshots? It is can help us solve the problem better.

Have a nice day!

Thanks,
Echo Du
Frank LOH 21 Reputation points

2021-04-29T14:40:22.197+00:00

Hi @Echo Du_MSFT ,
the enclosed screenshots correspond to the sequence above from adfs > Sharepoint custom app > to the prompt from reporting services.

Thanks.
Frank LOH 21 Reputation points

2021-04-30T09:07:48.167+00:00

Would like to clarify that the Sharepoint custom app was able to reach SSRS for authentication, as per the screenshot above. However the same credential used for ADFS wont' work. I tested with a Windows logon account and was able to access SSRS reporting. However this is not a solution because the Sharepoint/SSRS server is in a different domain and it's not logical to ask them to provide an account from their AD.

Share via

Sharepoint ADFS with SSRS report

1 answer

Your answer