Resolved: Login failed for user NT AUTHORITY\ANONYMOUS LOGON - Delegation Step-by-Step
New #Blog Post: Configure Linked Servers with Delegation - Step-by-Step - To fix those "Login failed for User NT AUTHORITY\ANONYMOUS LOGON" errors #Microsoft #SQLServer #MadeiraData
Problem Sometimes when trying to access a linked server, you’d get an error saying “Login failed for user NT AUTHORITY\ANONYMOUS LOGON”. This happens because you’re connected using Windows authentication, and SQL Server fails to “forward” your credentials to the linked server. This is an issue that I see coming up quite often, but very difficult to find a solution for it. Solving it involves a…
View On WordPress













