Home Forums SQL Server 2005 SS2K5 Replication sql server replicatoin requires actual server name to make a connection to the server RE: sql server replicatoin requires actual server name to make a connection to the server

  • hi,

    You cannot name your IP, by giving an alias name, sql server replication does not accept it.

    *************

    Procedure alias name for your IP

    Edit hosts (windows\system\driver\etc - using notepad

    xxx.xxx.xxx.xxx alias name

    **************

    this is not accepted in the replication.

    Finally I have creaed a VPN between these two networks and in both the machins i have resolved the IP by a Name which is now valied between thse two machines. Once VPN is established, these two locations become a local network and now your replication works.

    Thx anyways

    r. ganesh