I have 2 SQL Servers connected over internet, I can connect (with no problem) from each one to other using SQL Server Management Studio by using
publicIP,1433\server as server address.
So, I created a publication on server1 called
PUB1 but if I try to create a subscription (from server1) to server 2, I get this error message
TITLE: Connect to Server
Can not connect to MyPublicIP,1433 .
ADDITIONAL INFORMATION :
SQL Server replication requires the real name of the server to establish a connection. Connections via alias, IP address or other reference are not supported. Enter the real name of the server, " SERVEUR\SERVER ". ( Replication.Utilities )