October 20, 2003 at 4:47 am
Hello All,
I have setup replication between 2 SQL Server 2000 (W2K SP2, SQL 2000 SP3). Replication works fine but now I want to encrypt the communication between the Publisher\Distributer (Server A) and the client (ServerB). I have used Microsoft Certificate Server to generate a certificate for Server A using its FQDN, I have also ensured that Server B trusts the issuer of the certificate. I ran SETCERT.EXE and selected the certificate I had just imported. I then used the Server Network Utility on Server A to force encryption and successfully restarted the SQL Server service on Server A. So far so good until I actually have a look at the TCP/IP streams between Server A and Server B and I can clearly see Distribution jobs from Server A pushing data to Server B. No encrypted traffic!!! I have also tried a test certificate from Verisign with exactly the same results.
Can anyone shed any light please?
Cheers
Chris
October 23, 2003 at 8:00 am
This was removed by the editor as SPAM
October 23, 2003 at 2:56 pm
When you look at the network trace, do you the certificate go across at all?
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
K. Brian Kelley
@kbriankelley
October 27, 2003 at 6:00 am
quote:
When you look at the network trace, do you the certificate go across at all?
I don't see any communication in clear text that would suggest the certificate is being used. I have tested this on two machines one with the the Trusted CA and one without. I would expect to encrypted data on one and SSL failures on the other, but they both work but don't encrypt.
Cheers
Chris
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply