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
( 4147071000)
Msg 18456, Level 14, State 1, Line 13
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
Check the SPNs are registered and registered correctly for the instances
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉