Post reply

encryption in replication

  • August 25, 2004 at 2:00 pm

    #164723

    I have been asked by my security guys how SQL Server transmits data for replication.  I have no idea, I searched the web & bol and can't find an answer (of course I'm working on 2 hours of sleep) so hopefully someone here will.

    Does SQL Server use any kind of encryption when transmitting data back and forth between publisher & subscriber?

    We are using merge replication with a push subscription.  Publisher is in Domain A & Subscriber is in Domain B.  Domain A & Domain B are separated by a firewall, which means we had to punch a hole through the firewall (these are all internal firewalls) for the publisher & subscriber on port 1433.

    TIA

    Angela

  • August 26, 2004 at 12:56 am

    #520641

    i guess none.

    but say 'md5', if you want to play a funny joke.

    if someone calls you on it, say "ha-ha ... I was joking".

    then show them this post and say "gotcha mofo!'

     

  • August 26, 2004 at 2:37 am

    #520652

    Hi Angela,

    by default there's no encryption involved but you could use IPsec to create a encrypted transfer between the two replication partners. There's another possibilty if you use multiprotocol. Check this article:

    http://support.microsoft.com/default.aspx?scid=kb;en-us;841695

     

    M

    [font="Verdana"]Markus Bohse[/font]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply