I linked a SQL Server in Management Studio and when I test the connection, I do get "the test connection to the linked server succeeded." However, when I try to run a simple query, I get a message
Msg 18456, Level 14, State 1, Line 1
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
In my query I am using the linked server
Any suggestions will be appreciated. I am using SQL Server Management Studio 2017