Article ID: 830839 - View products that this article applies to.
Microsoft recommends that you use Microsoft SQL Server 2000 queues with queued updating subscriptions for transactional replication. However, if you are running Microsoft Windows 2000 Server on the Distributor and the Subscriber and you have taken steps to help protect your network, you can use Microsoft Message Queuing (also known as MSMQ) as the queuing mechanism at the Subscriber.
If you use Message Queuing, replication creates a queue on the Distributor. The login account that the SQL Server service runs under on the Distributor is granted read permissions and write permissions for the queue, and all the other login accounts are restricted. The login account that the Queue Reader Agent runs under on the Distributor must have read permissions for the queue. The login accounts that the SQL Server service runs under on each Subscriber must have write permissions for the queue. You can handle permissions in one of the following ways:
For more information about permissions for Message Queuing, see the "Access control for Message Queuing" topic in Windows 2000 Server Help.
Article ID: 830839 - Last Review: January 10, 2005 - Revision: 2.2
Contact us for more help