none
Agent message code 20084. The process could not connect to Distributor

    Question

  • Several subscriptions that were on a subscriber server that have the distribution job fired off on a scheduled basis (3-4a in the morning spaced out).

    Were working fine as of yesterday but we had to remove the publications and subscribers (after scripting them out) from the server that acts as the Publisher/Distributor (due to data file moves needed on some of the DBs which were moved to larger SAN volumes).

    Rebuilt the publications and subscriber from the scripts generated above.

    Now on the subscriber server the scheduled distribution jobs are failing with the following error:

    --First step history messages say (with success) ...

    Message
    The replication agent has been successfully started. See the Replication Monitor for more information.

    -- Second step message:

    Message
    2010-03-28 14:42:16.346 The timestamps prepended to the output lines are expressed in terms of UTC time.
    2010-03-28 14:42:16.346 User-specified agent parameter values:
       -Publisher MyPublisher
       -PublisherDB MyDB
       -Publication MyPublication
       -Distributor BURDC-SQL02P
       -SubscriptionType 1
       -Subscriber MySubscriber
       -SubscriberSecurityMode 1
       -SubscriberDB MySubscriberDB
       -XJOBID 0x58211FA1C93D8C4299028A3EA3A44895
       -XJOBNAME MyJobName
       -XSTEPID 1
       -XSUBSYSTEM Distribution
       -XSERVER MyServer
       -XCMDLINE 0
       -XCancelEventHandle 0000000000000A18
       -XParentProcessHandle 0000000000000A30
    2010-03-28 14:42:16.346 Startup Delay: 8299 (msecs)
    2010-03-28 14:42:24.643 Connecting to Subscriber 'MyServer'
    2010-03-28 14:42:24.721 Connecting to Distributor 'MyDistributor'
    2010-03-28 14:42:24.721 Agent message code 20084. The process could not connect to Distributor 'MyDistributor'.

    I am able to connect from the subscriber server to the Pub\Dist server via Mgt Sutdio.

    I have set the job to use a domain admin account that is for all of our SQL Server services across the environment

    The distribution jobs on the Pub\Dist server are there and can be started just fine for each of the publications that are failing

    Any help would be great - THANKS!

    Sunday, March 28, 2010 3:15 PM

Answers

  • Sounds like the distribution login account does not have rights on the distributor. You will need to address this problem.

    looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
    Tuesday, March 30, 2010 3:04 PM
  • Hi,

    Please check the account under which the Distribution Agent runs by using the following steps:
    1. Connect to the Publisher in Management Studio, and then expand the server node.
    2. Expand the Replication folder, and then expand the Local Publications folder.
    3. Expand the appropriate publication, right-click a subscription, and then click Properties.
    4. Click the properties button (...) in the Agent process account row to open Distribution Agent Security dialog box.
    5. Enter a Windows account or select run under the SQL Server Agent service account:
        For push subscriptions, the account must:
          1. At minimum be a member of the db_owner fixed database role in the distribution database.
          2. Be a member of the publication access list (PAL).
          3. Have read permissions on the snapshot share.
        For pull subscriptions, the account must at minimum be a member of the db_owner fixed database role in the subscription database.


    For more information, please see:
    http://technet.microsoft.com/en-us/library/ms189691(SQL.90).aspx

    If there are any more questions, please let me know.
    Thanks.


    ***Xiao Min Tan***Microsoft Online Community***
    Thursday, April 01, 2010 6:32 AM

All replies

  • Sounds like the distribution login account does not have rights on the distributor. You will need to address this problem.

    looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
    Tuesday, March 30, 2010 3:04 PM
  • Hi,

    Please check the account under which the Distribution Agent runs by using the following steps:
    1. Connect to the Publisher in Management Studio, and then expand the server node.
    2. Expand the Replication folder, and then expand the Local Publications folder.
    3. Expand the appropriate publication, right-click a subscription, and then click Properties.
    4. Click the properties button (...) in the Agent process account row to open Distribution Agent Security dialog box.
    5. Enter a Windows account or select run under the SQL Server Agent service account:
        For push subscriptions, the account must:
          1. At minimum be a member of the db_owner fixed database role in the distribution database.
          2. Be a member of the publication access list (PAL).
          3. Have read permissions on the snapshot share.
        For pull subscriptions, the account must at minimum be a member of the db_owner fixed database role in the subscription database.


    For more information, please see:
    http://technet.microsoft.com/en-us/library/ms189691(SQL.90).aspx

    If there are any more questions, please let me know.
    Thanks.


    ***Xiao Min Tan***Microsoft Online Community***
    Thursday, April 01, 2010 6:32 AM