Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqlserverdeveloper
Posting Yak Master
243 Posts |
 Posted - 2008-10-03 : 11:55:09
|
| Issue with our FTP job(SQL2000 server):We are executing FTP.bat file from the sql job as OS command in SQL2000, almost every other day we are seeing in the FTP output file as "connection closed by remote host", due to which the files are not getting FTP'ed from mas90 box(unix box) to SQL server. We are trying to see what might cause this to happen. The below are the contents of the FTP output file:C:\dir1\dir2 ftp -s:C:\commands.txt IPaddressConnected to IPaddessConnection closed by remote hostPer the above output file: we see connected to IP and then conn closed!!!Our networking team is saying that communication between mas90 box and sql server exists, they do'nt see any other problem.I am trying to find out if there are any other functions SQL is going at the time it attempts to connect for FTP.I checked the event log in the sql server, but can't find anything regarding that connection lost. I do'nt know where to look at to find what's causing closing the connection. In case if we have to check the mas90 unix box, what should we check for??Please advice, as I really do'nt know what to do at this time.Thanks!! |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-10-06 : 16:51:58
|
| Does your SQL Server Agent account have domain rights?If not then you will have a problem. The easiest way to test this is to log onto the SQL Server machine as the SQL Agent account and see if you can FTP to the destination manually. |
 |
|
|
|
|
|
FTP connection issue