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 --> Give Remote User & password for Local Login

3.Below that u can find a text 'For a login not defined in the list above,Connection will' with four radio button options

Select last option - Be made using this security context Remote Login with password.

This simple solution worked for me.

Thanks

Deepika