Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2003
    Location
    Delhi
    Posts
    2

    Unanswered: Merge Replication

    Hi

    Can help me with a minor problem in Merge replication. I am trying to perform merge replication on two SQL Server 2000 databases on Windows Nt 4.0 platform using TCP/IP and FTP. Have set everything in Publication and Subscriber for FTP and the subscriber can connect to publisher.

    I am getting the followiing error message afetr running replmerg.exe withh all required parameters for FTP.

    Microsoft SQL Server Merge Agent 8.00.194
    Copyright (c) 2000 Microsoft Corporation

    Connecting to Subscriber 'RAJ'
    Connecting to Distributor 'VTPL'
    Initializing
    Connecting to Publisher 'VTPL'
    Retrieving publication information
    Retrieving subscription information
    Snapshot files will be downloaded via ftp
    Connecting to ftp site 'VTPL'
    The subscription has been marked for reinitialization. Reinitialization will occur the next time you synchronize this subscription.
    The schema script '\\VTPL\C$\Program Files\Microsoft SQL Server\MSSQL\ReplData\ftp\VTPL_Caryaire_F2\2003010
    7120306\RightMain_1.sch' could not be propagated to the subscriber.
    Category:NULL
    Source: Merge Replication Provider
    Number: -2147201001
    Message: The schema script '\\VTPL\C$\Program Files\Microsoft SQL Server\MSSQL\ReplData\ftp\VTPL_Caryaire_F2\2003010
    7120306\RightMain_1.sch' could not be propagated to the subscriber.
    Category:AGENT
    Source: VTPL
    Number: 0
    Message: The process could not retrieve file 'VTPL_Caryaire_F2\20030107120306\RightMain_1.sch' from the FTP site 'VTPL'.
    Category:OS
    Source:
    Number: 12003
    Message: 200 Type set to I.
    200 PORT command successful.
    550 VTPL_Caryaire_F2\20030107120306\RightMain_1.sch: The system cannot find the path specified.
    550 VTPL_Caryaire_F2\20030107120306\RightMain_1.sch: The system cannot find the path specified.

    The process finished. Use CTRL+C to close this window.

    I am desparately in need of a solution. Can anyone help me out?

    Thanks and regards,
    Anamika

  2. #2
    Join Date
    Dec 2002
    Location
    NJ, USA
    Posts
    9

    Lightbulb merge replication

    I am not very familiar with SQL 2000 merge replication, but it sounds like you may have an FTP problem. Have you cheked to make sure that the ftp root has been set to where you need it ?

  3. #3
    Join Date
    Feb 2002
    Posts
    2,232
    I have not had much time but I was able to find a couple of references - let me know if these help.

    reference 1

    reference 2

  4. #4
    Join Date
    Jan 2003
    Posts
    1

    Re: Merge Replication

    You might want to make sure both servers are on the same Service Packs. I was burned by a bug in SP2 with regard to FTPing Snapshots.

    http://support.microsoft.com/default...b;en-us;318592

    Outside of that, I could only imagine it's a FTP setup issue.

    Kevin

  5. #5
    Join Date
    Nov 2003
    Posts
    3
    check service packs for sql server,
    also use DTS FTP to connect to your root, if you cannot it sounds like security.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •