One of the best articles on the web for configuring linked server connections. The part that describes what specific resources a provider must be granted access to before it will run out-of-process is especially useful, and I'm sure there is a long story with plenty or trial and error. Thanks.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho