J Livingston SQL (1/30/2012)
in 2008r2...sorry, havent got 2005 anymore...when creating the linked server there is a "security tab" that allows you you to specify the login to the remote server...have you checked this out?
I can confirm that the form is identical in 2005.
na1774, set your security settings and you should be fine.
-- Gianluca Sartori