Hi,

solution for this issue is give remote login user id and password in linked server properties.

1.Add linked server using sp_addlinkedserver 'server name'

2.Right Click -->Properties --> Security -->Add -->...