Shulou(Shulou.com)05/31 Report--

This article is about how to create a linked server in sqlserver. The editor thinks it is very practical, so I share it with you. I hope you can get something after reading this article. Let's take a look at it.

1. Expand the server object-- > linked server-- > right-click "New linked Server" Note: you must log in as a database administrator (usually the sa account) before you can create a "linked server"

two。 Enter the IP of the linked server

3. Set the security of the linked server

After completion, as shown in the following figure: now test it, log in to SqlServer locally with your account user, create a new query, and enter Select * From [linked server name]. [remote database name]. [owner]. [table name] such as Select * from [127.0.0.1]. [cntvs]. [DBO]. [t _ class] if there is no problem, you can query the data.

The above is how to create a linked server in sqlserver. The editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.