SQL Server Performance

Controlling what subscribers can see on the publication server

Discussion in 'SQL Server 2008 Replication' started by feenyx360, Apr 15, 2011.

  1. feenyx360 New Member

    Hello all,This is my first post here on SQLSERVERPERFORMANCE.com. I am pretty green when it comes down to SQL Server replication so I am looking for some assistance. I have about 20-25 SQL Server publications on SQL Server 2008. I would like to allow subscribers to monitor replication without being able to view other publication through replication monitor. I would also like to keep the subscriber from seeing other databases except for the one they have subscribed to when viewing the publication server through SQL Management Studio. I have tried executing the following prior to replication initiation: DENY VIEW ANY DATABASE TO myUser;However, the subscriber can no longer see the publication during setup if I execute this command on the user.Any help would be greatly appreciated.Thanks in advance!
  2. satya Moderator

    Welcome to the forums.
    When the replmonitor is used then I'm afraid by design its restricted due to member of the replmonitor fixed database role in the distribution database.

Share This Page