Log off Log on to SQL Server Reporting Services

Liviu Zaharia 1 Reputation point
2021-02-22T15:54:23.413+00:00

I think I used the wrong login and now it tells me that it is NT AUTHORITY\ANONYMOUS LOGON and I can't get out of this to log in again. Closing the browser and reopening it didn't help.

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

3 answers

Sort by: Most helpful
  1. Joyzhao-MSFT 15,566 Reputation points
    2021-02-23T02:27:23.667+00:00

    Hi @Liviu Zaharia ,
    I’m sorry I don’t quite understand what you mean,Have your checked the SSRS error log and could you share it? Do you mean login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’ with SQL Server Reporting Services? If so, please refer to : LOGIN FAILED FOR USER ‘NT AUTHORITY\ANONYMOUS LOGON’ WITH SQL SERVER REPORTING SERVICES.

    In Windows, you have security principal called 'NT AUTHORITY\ANONYMOUS LOGON'. when you would like to add / deny permissions to anonymous user you can use this pricipal.

    When the application cannot pass or delegate the security credentials to SQL Server, the application will identify the connection as "NT AUTHORITY \ ANONYMOUS LOGON".

    Anonymous authentication directs the report server to ignore authentication header in an HTTP request. The report server accepts all requests, but call on a custom ASP.NET Forms authentication that you provide to authenticate the user.

    Specify Custom only if you are deploying a custom authentication module that handles all authentication requests on the report server. You cannot use the Custom authentication type with the default Windows Authentication extension.

    For detailed information, you could refer to :Authentication with the Report Server.

    Also, you need to check if the configuration is correct , see the first link.

    Regards,
    Joy


    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.


  2. Olaf Helper 40,816 Reputation points
    2023-07-24T06:29:11.6933333+00:00

    Which browser are you using? Have you entered credentials to logon to SSRS? If then delete stored credentials.


  3. Michael Taylor 48,311 Reputation points
    2024-04-17T14:10:57.93+00:00

    Sounds like maybe you are connecting to your SSRS UI and you don't have Windows Auth enabled in the browser so it is logging you in using the guest account. Clear your credentials in the browser cache via settings if this is Chrome. You can also use Credential Manager in Windows, go to your Web Credentials (and maybe Windows Credentials as well??) tab and remove any instances of SSRS. Then relaunch the browser.

    0 comments No comments