How can i obtain encrypted communication between two SQL
Servers 2000 using Replication?
ThanksSee the following kb articles on setting up protocol encryption.
This will encrypt all the traffic, not just Replication related calls.
316898 HOW TO: Enable SSL Encryption for SQL Server 2000 with Microsoft
http://support.microsoft.com/?id=316898
276553 HOW TO: Enable SSL Encryption for SQL Server 2000 with Certificate
Server
http://support.microsoft.com/?id=276553
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||OK, thanks. In my case i should Force Protocol Encryption on the server beca
use if i use it on the client... How can i indicate to the Subscriber that t
he comunication with the Publisher must be Encrypted without using Force Pro
tocol Encryption in the Sub
scriber Server?|||It's either or. If you want ALL communication to the Server/Publisher
encrypted, then enable it on the server.
If you only want communication from the Subscriber to the Publisher
encrypted, then only enable it there. So, you only turn it on in one
place, at the server or at the client. If the client has this bit turned
on, the server knows how to handle the request when the client connects.
The client needs to Trust the same CA that issued the cert. This is all
documented in the kb articles I forwarded.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
Showing posts with label sqlservers. Show all posts
Showing posts with label sqlservers. Show all posts
Sunday, March 11, 2012
Subscribe to:
Posts (Atom)