Creating a subscription to the transactional publication RRS feed

  • General discussion

  • I try to create the subscription and processes were finished successfully. However, in the subscriber server, I did not see the db.  I checked "to view the synchronization status of the subscription", I found the error message said: The process could not connect to Subscriber "xxxxxx".

    The error message is below: 

    SQLServerAgent Error: Request to run job XXXXXX (from User XXXX- my domain user) refused because the job is already running from a request (from sa as the database owner is sa) by Start Sequence 0.
    Changed database context to 'XXXX'. (.Net SqlClient Data Provider)

    Any ideas to fix this?

    Wednesday, June 7, 2017 9:22 PM

All replies

  • Just to clarify u do not see database that is a subscriber db? 

    Agent is failing because of these things:

    1. The subscriber database has been dropped (somehow). 

    2. The account that is used to connect to subscriber do not have enough permissions to access that database (you need to modify subscription configuration and use correct user or grant permissions on subscriber)

    Try also change job ownership (distribution agent) on Distributor to distributor_Admin or sa.

    Thursday, June 8, 2017 7:39 AM