Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Ports required for Transactional Replication SQL 2008 and SQL 2005

53 views
Skip to first unread message

zaw

unread,
Mar 29, 2010, 3:51:33 PM3/29/10
to
We have engaged a partner to implement a design for data transactinoal flow,
bi-dreictionally, between our web store at one physical location and our
ERP, at another physical location.

They have choose to go with transactional replication. My interanl staff
reccomended
Merge replication, but, for reason beyond my scope of knowledge, our partner
has opted
to go with transactional due to issues they encountered attempting to
replicate with
Merge.

Now the debate is over which ports are required to be assigned/opened to
support
transactional replication.

My internal staff, which is heavily focused on security and desires oly the
minimal amount
of ports opened or assigned, says only 1433 TCP and 1434 UDP are required.

Our partner indicates that additional ports are required. Ports above 1024
are needed so
they recommended the following policies be added to our firrewall;
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
To configure the firewall, you must allow traffic from *ANY* to 1433, and
from 1433 to *ANY*, where *ANY* is a port greater than 1024.

*ANY* -> 1433

1433 -> *ANY*

This example uses 157.54.178.42 as the IP address of SQL Server and
157.54.178.31 as the client IP address. The ports opened by the client are
1746, 1748, and 1750 respectively.

Proto Local Address Foreign Address State

TCP xxx.xx.178.42:1433 0.0.0.0:0 LISTENING

TCP xxx.xx.178.42:1433 xxx.xx.178.31:1746 ESTABLISHED

TCP xxx.xx.178.42:1433 xxx.xx.178.31:1748 ESTABLISHED

TCP xxx.xx.178.42:1433 xxx.xx.178.31:1750 ESTABLISHED

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

What do you recommend or what is required to suport the function of

transactinal replication?

Let me know if additional data is needed to provide an answer.

Thank you,

ZAW

0 new messages