Skip to content
WordsOnTech
  • Home
  • MS SQL Server
    • SSRS
    • Always ON
    • Failover Cluster
    • Performance Tuning
    • Replication
  • AWS
  • Azure
  • Scripts
  • About Us
  • Join Us

SSRS

SSRS report issue – Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’

May 12, 2021 by Nitin

Issue Summary A few days back, a user complained that SSRS report is not working for him and he is getting below error message: An error has occurred during report processing.(rsprocessingAborted) Query execution failed for dataset ‘DataSet1’.(rsErrorExecutingCommand) Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’ Initial Investigation When we initially started looking into the issue, we … Read more

Share this:

  • Click to share on X (Opens in new window) X
  • Click to share on Facebook (Opens in new window) Facebook
  • Click to share on LinkedIn (Opens in new window) LinkedIn
  • Click to share on WhatsApp (Opens in new window) WhatsApp
  • Click to share on Pinterest (Opens in new window) Pinterest
  • Click to print (Opens in new window) Print
  • Click to share on Reddit (Opens in new window) Reddit
  • Click to share on Telegram (Opens in new window) Telegram
  • Click to share on Pocket (Opens in new window) Pocket
  • Click to share on Tumblr (Opens in new window) Tumblr

Like this:

Like Loading...
Categories MS SQL Server, SSRS Tags Anonymous logon, double hop, Kerberos, Login Failed, missing SPN, reporting services, service principal name, SPN, SSRS

Recent Posts

  • Out of memory exception in SQL Server Management Studio (SSMS) while opening ‘restore database’ page March 7, 2024
  • Using Snapshot Replication for Schema Transfer/Refresh Only March 7, 2024
  • Cleanup Log-shipping configuration through TSQL March 7, 2024
  • Configure non-default PostgreSQL instance for automatic start on machine start in RHEL March 4, 2024
  • Código de error: 22903, texto: “Ya hay otra conexión ejecutando ‘sp_replcmds’ para la captura de datos modificados en la base de datos actual.” March 4, 2024

AlwaysOn Amazon Web Services AWS AWS CLI AWS EC2 CDC Cloud costs Commvault cost monitoring cost optimization AWS encrypted backup Encryption Error 912 error 3417 Error 15151 Error 20011 Error 22017 Error 22307 Error 22903 HIGH CPU USAGE High Memory Issue Index optimization Login Failed LogShipping MS SQL Server MS_SSISServerCleanupJob Ola Hallengren Performance Tuning PowerShell Replication Replication Jobs S3 script Security SQL Server SQL Server 2017 SQL server 2019 SQL Server Backup SQL Server hacks SSIS_hotfix_install TDE TLOG Backups TSQL wait statistics Wait types

© 2025 WordsOnTech • Built with GeneratePress
%d
    We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.Ok