Tom,

You may want to consider using pass-thorough  authentication.  This would make your enterprise more secure, as no passwords will be hard-coded into the linked server.
It will, however,...