How do I fix Login failed for 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 IUSR?
NT AUTHORITY\IUSR is a built-in Windows account that is the default identity used when Anonymous Authentication is enabled for your application.
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.