question

FrankLOH-9590 avatar image
0 Votes"
FrankLOH-9590 asked FrankLOH-9590 commented

Sharepoint ADFS with SSRS report

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?

office-sharepoint-server-administrationadfs
· 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.

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.

0 Votes 0 ·

1 Answer

EchoDu-MSFT avatar image
0 Votes"
EchoDu-MSFT answered FrankLOH-9590 commented

Hello @FrankLOH-9590 ,

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

92409-sql-server-2014-sp2.png

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.





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

@EchoDu-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.

  1. User goes to the Sharepoint site federated with ADFS

  2. User redirected to ADFS for authentication

  3. Once authenticated, user gets redirected to Sharepoint site.

  4. 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.

0 Votes 0 ·

Hi @FrankLOH-9590 ,

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

0 Votes 0 ·

92578-2-adfs-sign-in-page.png92579-3-custom-page.png92610-4-redirects-to-report-server.png



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

Thanks.

0 Votes 0 ·

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.

0 Votes 0 ·