How to set up a linked server (Enterprise Manager)

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.