Advertisements
Home > SQL Errors, Tools, Troubleshooting > Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’ with SQL Server Reporting Services
  1. Eddie
    September 13, 2016 at 2:37 pm

    Mohit,

    Have you even run into someone who has completed these steps, yet still has the same error?

    That is exactly where I am….

    All suggestions welcome.

    Eddie

  2. September 13, 2016 at 3:04 pm

    Nope I have not. Can you please describe you’re configuration please? Some of the things that come to mind is protocol of communication, valid ports, NetBIOS name vs long server names, etc. Make sure your server does gets resolved correctly to FQDN that you registered.

  3. Chris Conner
    May 12, 2017 at 11:02 am

    I am currently having this issue with only one user. I am able to run my report fine, with Kerberos, but when he runs it, he gets the anonymous error mentioned above.

  4. darylx2
    July 23, 2018 at 11:26 am

    It works like a charm! Thank you so much!

  5. Tait W Burns
    May 10, 2019 at 10:34 am

    What is the sql report server is using an instance? http://servername:80/ReportServer_SQL01

    • Tait W Burns
      May 10, 2019 at 10:35 am

      Do you still just have an entry for the SPN like http/servername.FQDN and nothing else?

      • May 10, 2019 at 10:41 am

        Correct. SPN do not know anything about instance names. They are a pair of server and port configuration combined. Therefore, as long as your SSRS is listening on port 80 as in your example, SPN would be HTTP/ServerName.Domain.Com. If you are using non-standard port, then HTTP/ServerName.Domain.Com:Port is also required. In some scenario, you might also need to make NetBIOS name also; HTTP/ServerName and HTTP/ServerName:Port.

  1. June 16, 2014 at 8:04 am
  2. June 17, 2014 at 2:57 pm

Leave a Reply to Chris Conner Cancel reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: