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.

'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