Replication problems

I am still having difficulties setting up replication, so here is what I am
doing and tell me if I am missing something
1. all 3 sites are not on a domain, they are on the same vpn
2. Configured idential account and password on all machines
3. set the SQL server and SQL Sqerver Agent to run under this account at
start up
4. added entries for each site to LMHOSTS of the others for lookup
5. Enabled SQL Server for TCP/IP
6. Shared replData folder on Publisher/Distributer
7. Setup a table on central computer as a publisher
8. created pull subscriptions on hosts
I am able to get one host to transfer data but not the other
Steve Hall
What error message are you getting? Can you ping the publisher from the
failed host?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Steve Hall" <SteveHall@.discussions.microsoft.com> wrote in message
news:11C2AE7D-8A1A-444B-B607-1A33B64D53B6@.microsoft.com...
>I am still having difficulties setting up replication, so here is what I am
> doing and tell me if I am missing something
> 1. all 3 sites are not on a domain, they are on the same vpn
> 2. Configured idential account and password on all machines
> 3. set the SQL server and SQL Sqerver Agent to run under this account at
> start up
> 4. added entries for each site to LMHOSTS of the others for lookup
> 5. Enabled SQL Server for TCP/IP
> 6. Shared replData folder on Publisher/Distributer
> 7. Setup a table on central computer as a publisher
> 8. created pull subscriptions on hosts
> I am able to get one host to transfer data but not the other
>
> Steve Hall
|||The message I am getting is
"The merge process detected a mismatch while evaluating the subscriber
partition"
I also noticed that the subscribers cannot add rows to the subscribed article.
Site1 says - "Pull" "Succeeded" "No Data needed to be merged. The Step
Suceeded"
Site 2 says - - "Pull" "Succeeded" "The merge process detected a mismatch
while evaluating the subscriber partition"
CentralSite says - Site1 - "Pull" "Active"
CentralSite says - Site2 - "Pull" "Deactivated"
I am trying to get each subscriber to add data to the article and the
central site to collate this in its table. I have the publication set to
dynamically filter on HOST_NAME()
Steve
"Hilary Cotter" wrote:

> What error message are you getting? Can you ping the publisher from the
> failed host?
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "Steve Hall" <SteveHall@.discussions.microsoft.com> wrote in message
> news:11C2AE7D-8A1A-444B-B607-1A33B64D53B6@.microsoft.com...
>
>
sql