Eitan Blumin

Jun 4, 2023

How to Fix the "Login Failed for User NT AUTHORITY\ANONYMOUS LOGON" Error with Linked Servers

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:

  1. Enable SPN registration

  2. Enable delegate Kerberos authentication

  3. Configure SQL Server service accounts

This will help you fix the issue, without using any silly workarounds or dangerously misconfiguring linked servers.

Click here to read the full step-by-step guide on my website

    0