在Windows Server 2008讓SQL Server Agent 2008可以穿過Windows 防火牆使用FTP connection的方法

 

用Command視窗執行下列指令：

1. To open port 21 on the firewall, type the following syntax then hit enter:
   

   netsh advfirewall firewall add rule name="FTP (non-SSL)" action=allow protocol=TCP dir=in localport=21

2. To enable stateful FTP filtering that will dynamically open ports for data connections, type the following syntax then hit enter:
   

   netsh advfirewall set global StatefulFtp enable

轉載自：
FTP Task Blocked When Run in SQL Server Agent

Advertisements