Contents
Linked Server Error “Login failed for user ‘NT AUTHORITY\\ANONYMOUS LOGON’” 1 Both windows and SQL logins can be used for ‘Local Users’ 2 Only SQL logins can be used for ‘Remote Users’ 3 To user SQL logins for both local and remote users, local and remote SQL should have same SQL login and password. 4 Windows groups cannot be used in ‘Local Users’
Why is SQL login failed for NT authority \\ anonymous?
I would connect to the server using SSMS, enter my username and password, and then be prompted for the MFA authorization. After I authorized the logon, I would then receive the error shown in the main image: Login failed for user ‘NT AUTHORITY\\ANONYMOUS’ and Error 18456.
Where did the error ” Login failed ” originate?
Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Login failed for user ‘NT AUTHORITY\\ANONYMOUS LOGON’. An unhandled exception was generated during the execution of the current web request.
Why is linked server error ” Login failed for user “?
Linked Server Error “Login failed for user ‘NT AUTHORITYANONYMOUS LOGON’” 1 Works for Windows authentication / windows domain accounts. 2 These windows accounts should have access to resources to resources on third tier or remote SQL instance. 3 This option needs Kerberos authentication as it obviously creates a double hop scenario More
To summarize, The Login failed for user ‘NT AUTHORITYANONYMOUS LOGON’ error in both our cases seems to be caused by a service not running and/or not on the right user. Ensuring the right SPN or other Service is running and under the correct user should solve the anonymous part of the problem.
Can a NT authority user be a SharePoint user?
Actually i faceed similar issue in SharePoint after upgrading to SP2, After lot of investigation , i created a ‘NT AUTHORITY\\ANONYMOUS LOGON’ user in SQL Server logins and Identity Imporsonate=”true” in web.config. It is working fine for me. Thanks, your question is helped me to fix my issue.
Exception Details: System.Data.SqlClient.SqlException: Login failed for user ‘NT AUTHORITY\\ANONYMOUS LOGON’. An unhandled exception was generated during the execution of the current web request.