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