Setting Up Linked Servers Through Enterprise Manager
Although you can set up linked servers and login mappings by directly executing these stored procedures, they can also be set up easily through Enterprise Manager.
To create a linked server, follow these steps:
Open Enterprise Manager.
Click the plus sign next to the local SQL Server.
Click the plus sign next to the Security folder.
Right-click Linked Servers and choose New Linked Server (see Figure 19.5).
Figure 19.5. Creating linked servers through Enterprise Manager.
The General tab of the New Linked Server property box is displayed. The fields in the Server Type section ...