Learn how to resolve the common "double-hop pass-through authentication" issue that causes the "Login failed for user NT AUTHORITY\ANONYMOUS LOGON" error while trying to access a linked server with Windows authentication.
Follow this easy-to-understand step-by-step guide that explains how to:
Enable SPN registration
Enable delegate Kerberos authentication
Configure SQL Server service accounts
This will help you fix the issue, without using any silly workarounds or dangerously misconfiguring linked servers.