Re: Timeout error when using FTP from Windows DOS prompt

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Alun Jones [MSFT] (alunj_at_online.microsoft.com)
Date: 10/12/04


Date: Tue, 12 Oct 2004 16:17:59 -0700


"Eli Tucker" <eli-msdn@mailinator.com> wrote in message
news:O3hVN5JsEHA.2340@TK2MSFTNGP11.phx.gbl...
> I'm trying to download 253 files. Depending on the client machine and
> network that I try to transfer from, 4 to over 50 files are transferred
> successfully before the error.

I've seen it happen with a very few files in the case that the client is
behind a NAT router. Those devices can often have an even more restrictive
number of ports open for ephemeral connections by FTP clients, and they are
very often not configurable for more.

> You stated that the windows command line FTP client uses active mode to
> transfer files, and perhaps this is the root of the problem. I'm trying
to
> transfer a SQL Server snapshot (just a set of files) using SQL Server
MSDE,
> and it uses FTP to transfer files. It appears to be using active FTP
mode,
> but I suppose asking about using passive mode is a question for the SQL
> Server group.

Absolutely spot on. I wouldn't be too surprised if there were some SQL
experts here, but it would only be by coincidence, rather than design.

> You mention that one of the solutions would be to have the client
"increase
> the range of ephemeral ports alloted by the client (this may be difficult
if
> the client is behind a restrictive firewall or NAT)". How would one go
> about doing this?

Sorry - I forgot to include the link to
http://support.microsoft.com/?id=196271

Alun.
~~~~



Relevant Pages

  • Re: Access 2007->SQL Server2005 "connection was forcibly closed",G
    ... I think it will ameliorate the situation if you clean up the client as ... And to come back to my problem: I think with help of the SQL Server admins ... closed connections - but all of these errors are in the version which used ... Every new client opens again 30 connections if I open 30 tables ...
    (microsoft.public.sqlserver.connect)
  • Re: Best way to populate webpages from multiple tables
    ... tables within hash tables, custom classes etc. ... > Set a session expiring cookie at the client that stores the Customer ID. ... > send it to the client, instead store it in your session mgmt sql server - ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Best way to populate webpages from multiple tables
    ... tables within hash tables, custom classes etc. ... > Set a session expiring cookie at the client that stores the Customer ID. ... > send it to the client, instead store it in your session mgmt sql server - ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Access 2007->SQL Server2005 "connection was forcibly closed",G
    ... an Access database in former times this was a lot of work which took me ... closed connections - but all of these errors are in the version which used ... the SQL Server 2000 and everything worked ... client for programming easy, fast and good applications. ...
    (microsoft.public.sqlserver.connect)
  • Re: SQL and Bandwidth use
    ... In addition to the other responses, take a look at the memory and CPU usage ... in Great Plains Client software. ... > near 100Mb/sec bandwidth). ... Client PC is on same segment as SQL server (not passing through ...
    (microsoft.public.sqlserver.server)