• The client wants to use SSL between 2 sites over internet for replication.

    The question they are asking is, is there a way to mask/hide the actual server name , say using Alias in sql manager -

    For example if server was server1.company.com as the FQDN - using sql server configuration manager sql native client - alias and add "DUMMY1"

    Could they use DUMMY1.company.com as the FQDN for replication between site

    From technet

    http://msdn.microsoft.com/en-us/library/ms191192.aspx

    "The certificate must be issued for Server Authentication.

    The name of the certificate must be the fully qualified domain name (FQDN) of the computer"