Controlling outbound IP address on a SQL Cluster

Hello,

Is there any way to specify which IP address is used when executing a SQL Job. We recently found that Jobs starting from our cluster (Windows 2003 SQL 2000 SP 4 in a Active / Passive configuration) use the IP address from the local node rather then the virtual IP address tied to the SQL cluster. Jobs executing from the remote SQL server are running. The use of the local address has caused a failure at the firewall.

Thanks

mjdenn

Moving to the right alias so SQL Agent experts can reply to your question.

Thanks,

Zhiqiang Feng