SSRS Login error

Avyayah 1,291 Reputation points
2020-10-26T22:23:51.31+00:00

An error occurred during client rendering.
An error has occurred during report processing.
Query execution failed for dataset 'X'.
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

SSRS user has grant permission on stored procedure. SSRS reporting user also has access to the database.

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,993 questions
0 comments No comments
{count} votes

4 answers

Sort by: Most helpful
  1. ZoeHui-MSFT 40,511 Reputation points
    2020-10-27T01:50:18.44+00:00

    Hi @Avyayah

    "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

    Regards,

    Zoe


    If the 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.

    0 comments No comments

  2. Avyayah 1,291 Reputation points
    2020-10-27T16:56:09.96+00:00

    There are other reports that has direct datasource connection and is able to run without any issues. But one of the stored procedure is using the linked server and output the error when running report. Added both report server user and datasource user to the security properties of the stored procedure. Also granted execute privilege to stored procedure of report server and datasource user.

    Can the stored procedure use linked server to connect to the server for generating report? If yes, what is the command to execute so it output the data


  3. Beancurd 1 Reputation point
    2021-11-29T07:41:41.893+00:00

    If your SSRS setup similar to the one below. You're likely running into a common SSRS Reporting Service Double Hop (aka Negotiate / SPNego / Kerberos/ SSO) issue.

    Clients e.g. PCs -> SQL Server A (Hop 1) with SSRS -> SQL Server B (Hop 2) contains DBs where your SSRS data sources are pointing to.

    There're 2 solutions to this. Solution 1 is to hardcode credential in each Data Source. Solution 2 is to configure Kerberos Authentication (SPN + Account Delegation). There 3 places need to be configured correctly in order for it to work properly. May be easier to watch the following video which explains things a bit better.

    1. SPN & Service Account Delegation on Domain Controller
    2. Authentication Type in SSRS Configuration File rsreportserver.config on the SSRS Server
    3. App/Script such as Browsers, Web Apps, Python, PowerShell, etc. Integrated Authentication Settings, Additional Modules, Add-ons, etc.

    SSRS SQL Reporting Double Hop (aka Negotiate / SPNego / Kerberos/ SSO) ANONYMOUS LOGON Issues

    0 comments No comments

  4. Vinith Singh 0 Reputation points
    2024-01-09T14:29:39.9333333+00:00

    Hey guys! Follow this below article for detail about configuration and all the related settings.

    If you are new to this kind of error, then possibly this article will help from basic to advanced understanding of the issue and also further troubleshooting.

    https://kingfishertechtips.in/kerberos-issue-nt-anonymous-login-failed/

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.