| Event Id | 20604 |
| Source | MSSQLServer |
| Description | You do not have permissions to run agents for push subscriptions. Make sure that you specify the agent parameter SubscriptionType. |
| 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. |
| Reference Links | Microsoft product: SQL Server Version: 2000.80.760.0 Event Source: MSSQLServer Event ID: 20604 |
Catch threats immediately
We work side-by-side with you to rapidly detect cyberthreats
and thwart attacks before they cause damage.