ERROR - The process could not connect to Distributor

• MyTSQLRepl

  SSC Eights!

  Points: 824

  More actions

  July 27, 2011 at 7:51 am

  #241464

  I am setting transactional replication (pull) from 2005 to 2008 servers.

  I created subscriptions on SQL 2008 server to pull data from 2005 publication. But I get this error-

  The process could not connect to Distributor. It says my distributor is on publication.

  I am not sure how that happened? I thought pull subscription will always setup distributor at subscriber server not at publisher.

  Can someone please help me?

  Thanks,

• Suresh B.

  SSC-Insane

  Points: 22986

  More actions

  August 9, 2011 at 4:59 am

  #1365749

  No. Pull subscription does not setup distributor at subscriber. Distribution Agent runs at subscriber instead of at distributor.

  Your problem is related to security. Make sure that distribution agent has access to the distributor.