How do I fix login failed for user NT Authority anonymous logon?
Resolution:
- In SQL Server Management Studio go to Security. Expand Logins.
- Right click NT Authority\ANONYMOUS LOGON.
- Change the default database to the database that you are trying to access.
- In the left pane, click server roles. Check the sys admin server role.
- Click OK to save the changes.
What is NT Authority anonymous logon?
When the OS can't validate who you are, you are NT AUTHORITY\ANONYMOUS LOGON. You typically see this in double hop situations like when you have a client connecting to SSRS and SSRS isn't on the same server as the SQL Server where the DB is located.
How do I fix user login failed?
This problem should be resolved by following the below steps.
- Open your SQL Server Management Studio.
- Right click on the database server and go to properties.
- Choose the security option and check "SQL Server and Windows authentication mode".
- Enable TCP/IP connection in SQL Configuration Manager.
- Restart your SQL server.
What does anonymous logon mean?
An anonymous login is a process that allows a user to login to a website anonymously, often by using "anonymous" as the username. In this case, the login password can be any text, but it is typically a user's email address. Users are able to access general services or public information by using anonymous logins.