我如何在两台服务器中进行通信.我希望一些数据从 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]： 无法绑定侦听套接字： 地址已在使用中。

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