Very Computer

Hi,

  I have two SQL servers connecting over the internet. I donot have any
proxy set up but there is a firewall on both the sides and the port
1433 is given access at both the ends. I am new to replication. When I
push a merge subscription the schema and the initial data set are
transferred correctly to the subscriber but after that the merge agent
shows an error saying

"The subscription to publication 'databasename' is invalid."

I am not sure if the replication is done or not also.

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.

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
default.

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

Gavin Ringland
Network Engineer
Systems Network Ltd.
www.systemsnetwork.co.uk

Quote:> proxy set up but there is a firewall on both

Quote:> 1433 is given access at both the ends. I am new

Quote:> push a merge subscription the schema and the

Quote:> transferred correctly to the subscriber but

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 default.

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

Gavin Ringland
Network Engineer
Systems Network Ltd.
www.systemsnetwork.co.uk