SQL Server Performance

Dynamic Snapshot Replication

Discussion in 'SQL Server 2005 Replication' started by ndkrishna_1981, Mar 4, 2007.

  1. ndkrishna_1981 New Member

    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*
  2. MohammedU New Member

    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

Share This Page