The linked server gave me a lot problem before. It is sensitive to any update you applied to the server. At the end we choice to use ADO to replace...

try the following code:

select *

from [LikedServerName]...[AccessTableName]

We have the mixed authentication.

In the tracing file, the LoginName is showing correctly with the application sql login.