Export (0) Print
Expand All
Expand Minimize
1 out of 1 rated this helpful - Rate this topic

How to add a linked server login (Enterprise Manager)

SQL Server 2000

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)

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.