Asked by:
Getting this error Tranx Repl 2008R2 required privilege is not held by the client

-
Replication-Replication Transaction-Log Reader Subsystem: agent RTXHOU0VDBTST01\BOP-Vista_BranchOperations-1 failed. Executed as user: CORPORATE\TstARSDataUser. A required privilege is not held by the client. The step failed. I have tried this, but does not work.
Question
All replies
-
Ensure the Log Reader Agent process account is db_owner in the distribution and publication databases. This is covered in the section Permissions That Are Required by Agents in Replication Agent Security Model. If you are doing a sync_type of replicaiton support only, initialize with backup, or initialize from lsn then the Log Reader Agent process account must be sysadmin.
-
-
-
Automatic:
-- Adding the article synchronization object
exec sp_articleview @publication = N'Base_Vista_BranchOperations', @article = N'Zone', @view_name = N'syncobj_0x3631444641434631', @filter_clause = N'', @force_invalidate_snapshot = 1, @force_reinit_subscription = 1
GO
-- Adding the transactional subscriptions
use [Vista_BranchOperations]
exec sp_addsubscription @publication = N'Base_Vista_BranchOperations', @subscriber = N'RTXHOU0VDBTST01\RPT', @destination_db = N'Vista_Reports', @subscription_type = N'Pull', @sync_type = N'automatic', @article = N'all', @update_mode = N'read only', @subscriber_type = 0
GO
-
- Proposed as answer by Sofiya LiMicrosoft contingent staff, Moderator Monday, August 05, 2013 1:12 PM