One of the user who has DB owner rights on the database(dbs-sqlprod4), trying to access one of the view from the linked servers (dbs-sqlprod5) gets this error. If he runs it when is on prod4, then it works just fine.
However, I don't run into any issues since I have SA rights on prod4.
Select * from [dbs-sqlprod4].Farmreach.dm.ProfarmerNewsletter
Where FJID in
Msg 18456, Level 14, State 1, Line 13
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.