02-28-2014 01:04 AM
we are planning to setup OMW HA using transaction log shipping.
I tried searhing network ports required to be open between database of primary OM and secondary OM but could not find in any doc.
Can anyone provide me the list of the ports required for this failover.
thanks in advance!
02-28-2014 05:32 AM
As far as I know there are no specific port requirements from OMW point of view for setting SQL Log Shipping. OMW runs scripts using the SQL Agent Log Shipping jobs and so the two SQL servers must be able to remote connect to each other. You can find some details of it in the OMW Log Shipping Guide and also in the Microsoft SQL documentation on remote database access.
Hope this helps.