Groups | Blog | Home
all groups > sql server replication > march 2006 >

sql server replication : push snapshot


ACDMark
3/26/2006 2:45:07 PM
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.

Vijay TS
3/27/2006 12:56:01 PM
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
--
“This posting is provided "AS IS" with no warranties, and confers no rights.”


[quoted text, click to view]
Jose G. de Jesus Jr MCP, MCDBA
3/29/2006 8:20:04 AM
hi ,

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

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


[quoted text, click to view]
AddThis Social Bookmark Button