Home Forums SQL Server 2008 Security (SS2K8) Linked Server Error: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. RE: Linked Server Error: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

  • Kerberos authentication was likely set up. Was Kerberos delegation configured? This is required to go through the linked server connection to another SQL Server using the passed Windows credentials. If not, this whitepaper discusses how to do so for the linked server scenario.

    How to Implement Kerberos Constrained Delegation with SQL Server 2008

    K. Brian Kelley
    @kbriankelley