How to add a linked server login (Enterprise Manager)

To add a linked server login

1. Expand a server group; then expand a server.
2. Expand Security; then click Linked Servers.
3. In the details pane, right-click the linked server to which the login will be added, and then click Properties.
4. On the Security tab, click the local login to add.
5. Optionally, select Impersonate if the local login should connect to the linked server using its own user security credentials.
6. Enter the remote user and remote password that the local login should connect to the linked server with when not using the user’s security credentials (Impersonate not selected).

See Also

Security for Linked Servers