• Hello I am Having the same problem. Could anyone help me?

    Here is the scenario.

    1. I have 2 MS SQL Server 2005 each residing in different computers.

    server1> area1\sqlExpress

    server2> area2\sqlExpress

    2. I have already configured the Distributor to have the snapshot saved in the accesible drive (external hard disk, accessible to all)

    snapshot folder> \\extdrive\sqlsnapshot

    3. I have also used SQL Server Agent Authentication

    4. I have tried performing Merge Replciation and during first run,

    1. the process was performed and the database is copied to server2

    5. But when i try running the process again so that the changes in my subscriber will be copied to the publisher, (means no reinitialization in the subscriber), the SQL Server gives this message:

    The Server server2\SQLExpress is not a Subscriber. (.Net SQLClient DataProvider)

    I hope somebody could help me. Thank you.

    (Btw, I am new in replication)