How to add a linked server login (Enterprise Manager)

How to add a linked server login (Enterprise Manager)

To add a linked server login

1. Expand a server group, and then expand a server.
   
   
2. Expand Security, and 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 the Impersonate check box if the local login should connect to the linked server using its own user security credentials.
   
   
6. Enter the remote user and remote password with which the local login should connect to the linked server when not using the user's security credentials (Impersonate not selected).

See Also

Establishing Security for Linked Servers

How to set up a linked server (Enterprise Manager)