Of new help, two servers can ping each other, and both can remote login server, why create links server will appear the

CodePudding user response:

Use script to add? Instance name not ah?

CodePudding user response:

Prerequisite: network and ports are connected, remote login server does not know what do you mean SQL server can connect or Windows server connection

Please confirm that:

CodePudding user response:

refer to the second floor geredGuo response:

premise: network and ports are connected, remote login server does not know what do you mean SQL server can connect or Windows server connection

Please confirm:

(1) network links,
(2) to access the database each other ports, such as Telnet the other IP 1433
(3) the main link server server account password through SSMS methods such as connection from the library, and verify the account password and can connect remotely

If above is confirmed, reconfigure or error
So please post your configuration information, large probability is to configure the interface or code where I made a mistake;

CodePudding user response:

Nine times out of ten is the firewall, about 1433, or to turn off the firewall,

CodePudding user response:

Telnet to each IP 1433, confirm the port open, confirm whether closed or add firewall port 1433,