SSRS Report ignoring the Data Source credentials it is given, while other reports use the credentials properly

Question

I have an SSRS report deployed that works locally but not on the SSRS site. It is using a shared Data Source that has 40+ other reports using it as well. The issue is this report returns the following error:

Query execution failed for dataset 'dataset_name'. (rsErrorExecutingCommand)

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

It seems as if the report is ignoring the credentials provided to it by the Shared Data Source, but how would you go about figuring that out when so many other reports are using the credentials properly?

Answer 1

Hi @Shane Kelley

"NTAUTHORITY\ANONYMOUS LOGON" is the built in IIS account on your report server. The reports are being executed from this account which serves up the page to the user.

Please update your Data Source to use "As the user viewing the report".

You may also choose "Using the following credentials" to use stored credential.

For more information:

https://learn.microsoft.com/en-us/sql/reporting-services/security/authentication-with-the-report-server?view=sql-server-ver15

Someone also mentioned it could be Kerberos Issue, check the blog to see if it is helpful.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.