Post reply

SQL Transaction Replication to DMZ

  • March 21, 2011 at 3:57 pm

    #248521

    Guys,

    Is there any standard procedure to setup SQL 2008 Transaction to DMZ - like what prots are recommended, should sql borwser need to be turned off on SQL Instance in

    DMZ etc.

    Any suggestions/inputs would help.

    Thanks

  • March 23, 2011 at 7:31 am

    #1302447

    The replication uses port 1433 to communicate. This is the default port that SQL Server communicates with the client. But if you want to connect to the SQL Server on the DMZ using SSMS from your publisher or distributor for setting it up, then you have to open 1434 UDP port. Once it is set up you can close the UDP port. Here is link from MS that shows the details of Firewall configuration.

    -Roy

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

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