replication with ftp - cryptic ftp server 
Author Message
 replication with ftp - cryptic ftp server


We use a SQL2000 Server Standard (german) usind ADSL and a
MSDE2000 client (german) - dial in - to replicate data. We
set up 1 merge and 2 transact repl. using anonymous pull.
I had to change a transact repl and now i get the error
message that the client agent can't find the ftp server.
the ftp server is configured well (and the other repl.
work fine). When I check the agent details i see the
following message (sorry, its german but I think you can
see the problem):

Der Servername oder die Serveradresse konnte nicht
verarbeitet werden.
(Quelle:  (BS); Fehlernummer: 12007)
Der Prozess konnte keine Verbindung zu FTP-
Site 'బబํ&#364=
=FCber Anschluss =
402 herstellen.
(Quelle: AGENT (Agent); Fehlernummer: )

There are cryptic symbols but not the ftp address (the
real ftp address is the ip address of the server).

I hope someone can help me!

Thank you


Fri, 27 Aug 2004 22:44:24 GMT
 replication with ftp - cryptic ftp server


I'm using SQL Server 2000 in Spanish and I have exactly the same problem
than you with pull subscriptions (push subscriptions work fine). It seems a
bug of SQL Server.

Tue, 31 Aug 2004 00:14:30 GMT
 replication with ftp - cryptic ftp server
Hi Guys,

Check the service levels of both the publisher and the subscriber.  Make
sure everyone is at SP2.  There is a problem with FTP if the service pack
levels do not match.

Best of luck,

Chris Skorlinski, MCDBA
Microsoft SQL Server Support

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

Fri, 03 Sep 2004 22:53:33 GMT
 [ 3 post ] 

 Relevant Pages 

1. FTP : DataTransfer from server to a ftp site.

2. getting FTP site response in FTP custom DTS task using Internet Transfer Control - StateChanged event

3. FTP Task - Using "Passive FTP"

4. INX_UTIL Tool Kit 3.0 now available via

5. ftp to

6. DTS FTP Task: Is it possible to get beyond the root directory of the ftp site

7. Recent FoxPro-related FTP uploads to

8. Internet Replication using a FTP server

9. Does the FTP option of Merge Replication handle proxy servers

10. SQL Server 7 replication across FTP

11. snapshot ftp delivery error in merge replication

12. Replication using FTP

Powered by phpBB® Forum Software