To add a linked server to SQL Server

The overall analysis of the good there is a train of thought. Our goal is to complete a link to the remote server.

First: We want to know where this server is (that is, to know its IP address, if it is in the same network to know its computer name is also possible, because a server can install multiple instances of SQL Server, if we want to connect to a non-default instance when we want to specify the instance name)

Second: We want to log on to the target SQL Server server with that username.

Third: We are locally logged in with which user.

--------------------------------------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------- -------

The first step:

Step Two:

Specify where the server is,

　　

Step Three:

Specify Login Name

　　

Fourth Step:

Complete.

To add a linked server to SQL Server