SQL Replication between sites using SSL

• Spud312R

  SSC-Addicted

  Points: 462

  More actions

  October 8, 2014 at 4:24 am

  #291452

  I have sql ent configured with Encryption and want to setup sql replication between 2 servers at 2 different locations using SSL

  How do i go about this, i can see how SSL is used between SQL server and client apps, but couldnt find anything describing sql replication and the traffic using SSL encryption

• r Doda

  SSC Enthusiast

  Points: 101

  More actions

  October 9, 2014 at 3:06 pm

  #1751449

  This article was helpful to us:

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

  Read the first bullet about use of SSL or VPN to secure replication.

  We were able to configure encryption while replication with this approach. Only thing that I still can't figure out is how to encrypt the initial snapshot. If you figure that out, please do share.

  HTH,

• Spud312R

  SSC-Addicted

  Points: 462

  More actions

  October 24, 2014 at 2:54 am

  #1754557

  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"