October 5, 2007 at 9:31 am
We have a 'Reporting' group which needs access to view status of replicated transactions (we use Transactional Replication) via the 'Subscription Watch List' tab on Replication Monitor -- on the Publisher. In SQL 2000, this group was able to see the status. In SQL 2005 the group cannot.
They are using Windows authentication to register the SQL Server 2005 publication server. What privelege(s) do I need to grant to this Windows group to allow them to see the 'Subscription Watch List' status?
October 5, 2007 at 11:49 am
The replmonitor database role in the distribution database.
* Noel
October 5, 2007 at 12:11 pm
thx Noel.. much appreciated. A further description on this is located here:
How to: Allow Non-Administrators to Use Replication Monitor (Replication Transact-SQL Programming)
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/repref9/html/a3bdde8f-4f90-401f-b26a-dfe803534de7.htm
October 5, 2007 at 2:22 pm
DBASkippack (10/5/2007)
thx Noel.. much appreciated. A further description on this is located here:How to: Allow Non-Administrators to Use Replication Monitor (Replication Transact-SQL Programming)
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/repref9/html/a3bdde8f-4f90-401f-b26a-dfe803534de7.htm
Cool.
* Noel
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply