SSRS - Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' - As user viewing the report

Question

I'm trying to set a report in Report Server (SQL Server 2017 Reporting Services 14.0.600.1669) that use the Windows credentials of the user who is viewing the report to query the datasource (SQL Server 2017 14.0.3430.2).

The report is deployed and works correctly if I choose to specify static WAuth credentials in the datasource (Test connection success):

If I choose to ask the user for Windows credentials it works fine too:

BUT when I choose to access the data source as the user viewing the report (ME, with the same WAuth) I'm reciving the error:

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

So it seems to not be using my user but another service account. I've tried both with Microsoft Edge (IE 11 Compatibility Mode) and Chrome with the same result.

I'm not the person who have installed/configured this Report Server.

Can someone help me to find out what could be the problem/suggest what to check?

Thanks!

Answer 1

So, it seems it really was a double-hop authentication issue wich i managed to resolve with the help of IT. I don't know a lot about AD or Kerberos but this guide has been pretty helpful for me and IT to catch and resolve the missing configurations.