push snapshot

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ACDMark - 26 Mar 2006 23:45 GMT

Hi I'm trying to setup a push replication between 2 servers on different
networks. both machines can ping eachother using there machine names. I setup
the publication and the distributor on the push server and generate a
snapshot. I then run the distributor but it fails to connect to the
subscriber.

thanks for the help.

Mark

Reply to this Message

Vijay TS - 27 Mar 2006 21:56 GMT

You need to ensure the @@servername of the subscriber is how the
publisher/distributor refer to it and vice versa. If you have to use IP
address, you can setup client side alias on the distributor that maps the IP
address to the @@servername of the subscriber

Signature

“This posting is provided "AS IS" with no warranties, and confers no rights.”

> Hi I'm trying to setup a push replication between 2 servers on different
> networks. both machines can ping eachother using there machine names. I setup
[quoted text clipped - 5 lines]
>
> Mark

Reply to this Message

Jose G. de Jesus Jr MCP, MCDBA - 29 Mar 2006 17:20 GMT

hi ,

be sure that your sql agent services is
running on a domain account
that has permission to your snapshot folder
and the database

Signature

thanks,

------------------------------------
joey

> Hi I'm trying to setup a push replication between 2 servers on different
> networks. both machines can ping eachother using there machine names. I setup
[quoted text clipped - 5 lines]
>
> Mark

Reply to this Message