Dynamic snapshot Job not Executing

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Dynamic snapshot Job not Executing

Author

Topic

ndkicha_1981
Starting Member

1 Post

Posted - 2007-03-02 : 01:42:57

Hai all,

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.

I think the problem is with the DynamicFilterLogin property which I use.
Can somebody help me in that?.

(Source: KRISHNA (SQL-DMO); Error number: 21049)"
'5' is the database ID
'LoanProducts' is the publication name.

regards,
Krishna Kumar

The Code goes as show 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\]'

rlaubert
Yak Posting Veteran

96 Posts

Posted - 2007-03-02 : 07:56:51

Can you provide the code? Looks like some of the info is missing.

Raymond Laubert
MCDBA, MCITP:Administration, MCT

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources