I have been experiencing this problem and after
some messing about and discussions with Microsoft
have eventually found the solution.
We are replicating two SQL Servers across the
Internet and kept getting the same error message,
even though the replication worked.
What I ended up doing was changing the server
alias in the client network utility to be the
exact ntserver name. We had previously used the
fully qualified domain name which is used by
We thought this might have been a service pack
issue as the box on the Internet was running
gold. Although we didn't get a chance to apply
SP2 to it the problem has now been resolved.
Hope this is useful
Systems Network Ltd.
> I have two SQL servers connecting over the
internet. I donot have any
Quote:> proxy set up but there is a firewall on both
the sides and the port
Quote:> 1433 is given access at both the ends. I am new
to replication. When I
Quote:> push a merge subscription the schema and the
initial data set are
Quote:> transferred correctly to the subscriber but
after that the merge agent
> shows an error saying
> "The subscription to publication 'databasename'
> I am not sure if the replication is done or not
> Did anybody face this problem.
> Thanks for any help
> You can also reach me at
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Sent via Deja.com http://www.deja.com/
Before you buy.