Greg Edwards-268690 (12/9/2011)
...Good job giving a short overview. Many give up trying to set this up, and resort to workarounds.
I'm a DBA on some development and QA servers but not in production, so I have to request permission before I develope a database or job that leverages a linked server. Considering the issues involved, it's no wonder why many DBAs punt and configure the linked server to use SQL Server account authentication, or they just disallow the use of linked servers all together. This article is succinct and could be very helpful.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho