| Event Information | CAUSE:
A push Distribution Agent or a push Merge Agent must log in to the distribution server with an account that is a member of either the db_owner fixed database role in the distribution database or the sysadmin fixed server role.
RESOLUTION:
Use the subscription_type parameter of sp_addmergesubscription to create a pull subscription instead of a push subscription.
If you must use a push subscription, use the -DistributorLogin, -DistributorPassword, and -DistributorSecurityMode parameters on the "Run Agent" job step of the failing agent to configure the agent to log in to the distribution server as a member of either the db_owner fixed database role in the distribution database or the sysadmin fixed server role. |
