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, require Kerberos authentication to be configured, provided both servers exist in trusted domains.