all groups > sql server replication > october 2005 >
You're in the

sql server replication

group:

Pull replication


Pull replication Thang Long
10/6/2005 6:11:15 AM
sql server replication: I cannot get a pull merge replication to work.
The distributor is Win2000 running SQL 2000.
Subscribers are XP Pro running MSDE.

Agent command:

-Publisher [DistSVR] -PublisherDB [MyDB] -Publication [MyDB] -Subscriber
[SubSVR] -SubscriberDB [MyDB] -SubscriptionType 1 -SubscriberSecurityMode 0
-SubscriberLogin [sa] -SubscriberEncryptedPassword
[????????????????????????????????????] -Distributor [DistSVR]

The errors:

Category:AGENT
Source: SubSVR
Number: 20084
Message: The process could not connect to Subscriber 'SubSVR'.

Category:SQLSERVER
Source: SubSVR
Number: 17
Message: SQL Server does not exist or access denied.

Thank you ver much.

Re: Pull replication Hilary Cotter
10/6/2005 12:16:12 PM
This means your subscriber can't connect.

Log on to your subscriber machine and try to ping your publisher.

Also verify you can ping your subscriber using the host name SubSVR from
your subscriber. Also verify that your subscriber password is correct.

--
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
[quoted text, click to view]

RE: Pull replication Thang Long
10/10/2005 4:31:04 AM
Thank you for your reply.

Subscriber PC name and SQL server name are different. It's the reason ?
Excuse me for the question: SubscriberLogin is the login to Subscriber or
Distributer ?

Thank you.


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