How to set up a linked server (Enterprise Manager)

How to Install SQL Server 2000

previous page next page
How To

How to set up a linked server (Enterprise Manager)

To set up a linked server

  1. Expand a server group, and then expand a server.

  2. Expand Security, right-click Linked Servers, and then click New Linked Server.

  3. Click the General tab, and in the Linked server box, type the name of the server to link.

  4. Under Server type, click a selection.

    If you select Other data source, you will have to specify provider properties.

previous page start next page