Contents
How do I fix Login failed for user NT Authority anonymous logon?
Click the Delegation tab, select the Account is trusted for delegation check box, and then click OK. Finally you will also need to set all the machines as trusted for delegation. Once you’ve done this, reconnect to your sql server and test your liked servers. They should work.
What is NT AUTHORITY ANONYMOUS LOGON?
The login failure error ‘NT AUTHORITY\ANONYMOUS LOGON’ is generated on an mssql server when a Tenable product is used to scan mssql. Essentially when Nessus probes each port to determine which services are running, mssql will interpret this as an anonymous login. The log is generated by find_service.
How do I turn off NT Authority anonymously?
Solution
- Login as “Administrator” and click “Start > Run”.
- Type “regedit” in the box and click “Ok” button.
- Navigate to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa.
- Change the value of “RestrictAnonymous” from “0” to “1”
- Exit regedit and reboot the server.
How to login for NT authority anonymous logon?
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’
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.
What causes integrated authentication to fall back to NTLM?
Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. If your issue is with linked servers, you need to look at a few things. First, your users need to have delegation enabled and if the only thing that’s changed, it’l likely they do.
What to do if MFA logon fails to login?
What you need to do now, is to enter your full email address (AAD credential) as the Username after selecting to logon using MFA. If you don’t do that, again all goes but then right at the end, you get this error: