I have SQL Server 2000 with SP3 running on a windows 2003
cluster. I need to setup log-shipping from a SQL Server 7
database server. The 2 servers are separated by a
firewall. The guy that configures the firewall doesn't
want to do trial-and-error to figure out which IPs to open
up. I want to use DTS to call a Win32 process to copy the
files - which IP needs to be opened? The MSCS IP address?

Log Shipping through a firewall would require either port 445 or 135,139.
Neither of these options would be recommended for a firewall.

A VPN would be a better alternative. This would require port 500.

Thanks,

Kevin McDonnell
Microsoft Corporation

This posting is provided AS IS with no warranties, and confers no rights.

Just want to add that if you don't use the Microsoft log
shipping implementation or something similar to that
implementation, you may not need to open ports 445, 135,
or 139. For instance, you can set up a FTP job to ship the
backup files across your firewall and then have another
job picking up the backup files and restore them
accordingly on this side of the firewall.

Linchi