Linked server issue using Logins current security context

from desktop in management studio (ms) can connect server , run query like,

select top 1 * serverb.mydatabase.dbo.mytable, , seems working.  if leave , come after few minutes no longer works , error:

msg 18452, level 14, state 1, line 1

login failed user '(null)'. reason: not associated trusted sql server connection.

 

if remote connect server b , run query works , when try desktop ms starts working again.  ideas on why happening?

   have tried find solution problem in other threads in forum? there other threads similar questions , particular scenario has been discussed before.

 

  if existing threads not solve problem or if scenario somehow different other mentioned in forum please let know , please provide more detail on specific nature of problem.

 

 thanks lot,

-raul garcia

  sde/t

  sql server engine

 

SQL Server  >  SQL Server Security