How do I configure security for a Linked Server connecting to a remote SQL Server?
Under the Security tab, select 'Be made using this security context', then enter a remote login username and password for an account that has access to the target database on the remote server.