Dynamic snapshot Job not Executing

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*

Plz see my code below:

SET @STEP = 'Run agent - LoanProducts'
SET @CMD = '-Publisher [' + @Publisher + '] '
+ '-PublisherDB [' + @PublisherDB + '] '
+ '-Distributor [' + @Publisher + '] '
+ '-Publication [LoanProducts] '
+ '-ReplicationType 2 '
+ '-DistributorSecurityMode 1 '
+ '-DynamicFilterLogin [' + @DBID + '] '
+ '-DynamicSnapshotLocation [' + @UNCROOT + 'LoanProducts]'
PRINT 'Adding step ''' + @STEP + ''''
EXECUTE @ReturnCode = msdb.dbo.sp_add_jobstep
@job_id = @JobID,
@step_id = 6,
@step_name = @STEP,
@command = @CMD,
@database_name = 'Distribution',
@server = @Publisher,
@database_user_name = '',
@subsystem = 'Snapshot',
@cmdexec_success_code = 0,
@flags = 0,
@retry_attempts = 10,
@retry_interval = 1,
@output_file_name = '',
@on_success_step_id = 0, @on_success_action = 3,
@on_fail_step_id = 0, @on_fail_action = 2
IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback

Right the 'LoanProducts' publication and click properties...
Click on "ublication Access List" and add the loging to get the publication access and then try...


MohammedU.
Moderator
SQL-Server-Performance.com