October 8, 2014 at 4:24 am
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
October 9, 2014 at 3:06 pm
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,
October 24, 2014 at 2:54 am
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"
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply