Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

recently all my PULL subscriptions have this message in the synchronization status. :-

The process could not connect to Distributor 'DISTRIBUTIONDB'

This is only happening with the PULL subscriptions. I have attempted to reinitialize with a new snapshot, but the message remains.

when attempting to look at the history it suggests that the agent job doesn't exist. So I removed it and recreated the subscription and the job from a T-SQL script. monitor now suggests that the job doesn't exist but when run the T-sql sp_addpullsubscription code on the subscriber i get

Msg 21002, Level 11, State 1, Procedure sp_addpullsubscription_agent, Line 250 The Distribution Agent for this subscription already exists (YAZOO-MLT-Statics-KINKS-MLT-Replicated-94CD221C-4F8E-4732-8738-A6101E9D571B).

share|improve this question
    
I can resolve the issue by recreating my streams as push subscriptions but interested in the underlying reason, I had changed the allow_anonymous subscription option the other day, but reverted the change –  DamagedGoods Jul 5 '12 at 11:05

2 Answers 2

up vote 2 down vote accepted

This is a permissions issue, the Distribution Agent process account does not have rights on the distributor.

Verify the Distribution Agent process account is a member of the PAL, has read permissions on the snapshot share, and is a member of the db_owner fixed database role in the subscription database.

share|improve this answer

The account had been using the sa account so not sure why it failed even though this is a terrible config.

I have switched them to all be Push subscriptions on the remote distributor with a dedicated windows login that I have added into the PAL.

This can be accessed in the GUI by opening the publisher in SMSS > expand 'Replication' folder > right click the publication and selecting properties > Publication Access List (PAL)

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.