SQL Server Performance

Access denied at the subscriber end while synchron

Discussion in 'Performance Tuning for SQL Server Replication' started by santnair, Sep 14, 2005.

  1. santnair New Member

    Hi [<img src='/community/emoticons/emotion-1.gif' alt=':)' />],<br /><br />I am using merge replication with dynamic horizontal filter (on HOST_NAME()).Have two subscribtion. I am filtering using the HOST_NAME().One subscriber is getting the data.At the other subscriber showing error "Access denied to distributor.Login failed".<br /><br />I have given permission to the user to the shared replication folder<br /><br />Why is it so?<br />thanks in advance<br /><br /><br />Regards<br />
  2. satya Moderator

Share This Page