Create linked servers in SQL Server graphical tutorial _mssql

1. Expand the server object--> linked server--> right click "New Linked Server"

Note: You must be logged on as a database administrator (usually the SA account) before you can create a linked server

2. Enter the IP of the linked server

3. Set the security of a linked server

When finished, the following figure:

Now test, log on to SQL Server locally with account user, create a new query, and enter SELECT * from [linked server name]. [Remote database name]. [owner]. [Table name]
Like what
Select * FROM [127.0.0.1]. [Cntvs]. [dbo]. [T_class]
If you're okay, you can find the data.
The young under the Banyan tree