sql-server - 我如何在两个服务器中进行通信。我想要从 A 服务器到 B 服务器上的一些数据。如果我通过 Web 套接字进行通信，如果是，那么如何？

Question

我想访问从服务器1到服务器2的数据。我该如何做这件事，可以通过p隧道实现这一点。我尝试sudo ptunnel -p 192.168.0.66 -lp 8080 -da 192.168.0.66 -dp 9090这个p隧道在两台服务器上，但它给了我错误[err]:无法绑定(bind)监听套接字:地址已在使用中。

Answer 1

Follow these steps to create a Linked Server:

       Server Objects -> Linked Servers -> New Linked Server
       Provide Remote Server Name.
       Select Remote Server Type (SQL Server or Other).
       Select Security -> Be made using this security context and provide login and password of remote server.
       Click OK and you are done !!
        [HERE][1]ple tutorial for creating a linked server.

       OR

       You can add linked server using query.

       Syntax:

       sp_addlinkedserver [ @server= ] 'server' [ , [ @srvproduct= ] 'product_name' ] 
            [ , [ @provider= ] 'provider_name' ]
            [ , [ @datasrc= ] 'data_source' ] 
            [ , [ @location= ] 'location' ] 
            [ , [ @provstr= ] 'provider_string' ] 
            [ , [ @catalog= ] 'catalog' ] 
       Read more about sp_addlinkedserver.

       You have to create linked server only once. After creating linked server, we can query it as follows:

       select * from LinkedServerName.DatabaseName.OwnerName.TableName