have an error on linked server 'Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.'

Question

We have a linked server which was working ,now it is showing 'Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.'and any work around?

Answer 1

Hi @Wondi Woldetensay,

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.

Check it out here about the details.

https://eitanblumin.com/2022/11/02/configuring-linked-server-with-delegation-step-by-step/

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 2

'Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.'and any work around?

"Any work around" is to assign/mapping the right user credentials in the Linked Server security settings, see

Create linked servers (SQL Server Database Engine)

=> Edit the Security page for the linked server propertie

Answer 3

Hey guys! Follow this below article for detail about configuration and all the related settings.

If you are new to this kind of error, then possibly this article will help from basic to advanced understanding of the issue and also further troubleshooting.

https://kingfishertechtips.in/kerberos-issue-nt-anonymous-login-failed/