December 28, 2002 at 11:22 am
Can any expert help me regarding to the connection problem.
i have a publisher and distributor using the same machine. From the publisher where having only one publication with several articals.
i create a push subscription for that publication.
Snapshot agent can create the articals
** Distribution Agent is not able to synchorise the articals to the subscriber
ERROR message : The Process cannot connect to the subscriber "SubscriberName"
I can register the subscriber on the EM
The subscriber is SQL 2000 desktop engine
if the subscriber is SQL personal edition , there is fine.
Can i know, when distribution agent connect to subscriber, it use Windows auth or SQL login ?
December 28, 2002 at 5:46 pm
It can use either. Easiest way to see which you're using is to check the job for the distribution agent. It has the option to specify a userid/password if you want to go that route. Also has a logging switch you can use to write output to a file for debugging.
Andy
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply