SQL Server Performance Forum – Threads Archive
Dynamic Snapshot ReplicationHai, I have created a Job for doing Dynamic snapshot (merge replication). The job is not executing and it is displaying the following Error: *"The login ‘5’ does not have access permission on publication ‘LoanProducts’ because it is not in the publication access list.
(Source: KRISHNA (SQL-DMO); Error number: 21049)" ‘5’ is the database ID ‘LoanProducts’ is the publication name. *regards,
Error is self explanatory…
It is permission issue, Login does not have the access to publication…. Add the login to publication access list in publication properties…