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

Shane Kelley 0 Reputation points
2024-03-27T19:06:33.7833333+00:00

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?

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,807 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 33,126 Reputation points
    2024-03-28T02:50:25.7533333+00:00

    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.

    0 comments