Hai all,

     I an doing dynamic snapshot(merge replication) using a Job. I have created the Job but the Job is not running 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)

Source: KRISHNA - It is the server
'5' - denotes the DB Id
'LoanProducts' - Publication Name

I think the problem is with the DynamicFilterLogin parameter which I use.

plz anybody help me...

The Code for Running agent is as follows:
------------------------------------------
--Run the Agent on LoanProducts for this DBID
        
            SET @STEP = 'Run agent - LoanProducts'
            SET @CMD = '-Publisher [' + @Publisher + '] '
                     + '-PublisherDB [' + @PublisherDB + '] '
                     + '-Distributor [' + @Publisher + '] '
                     + '-Publication [LoanProducts] '
                     + '-ReplicationType 2 '
                     + '-DistributorSecurityMode 1 '
                     + '-DynamicFilterLogin [' + @DBID + '] '
                     + '-DynamicSnapshotLocation [' + @UNCROOT + '\LoanProducts\]'


regards,
krishna kumar