SQL Server Performance Forum – Threads Archive

Dynamic Snapshot Replication

Hai, 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,
Krishna Kumar*

---

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…
MohammedU.
Moderator
SQL-Server-Performance.com

---

]]>