By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,856 Members | 2,164 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,856 IT Pros & Developers. It's quick & easy.

LogReader Agent Lacks Required Privilege

P: n/a
I'm using our dev ID to set up peer-to-peer replication among three SQL
Server 2005 servers. The dev ID essentially has sa rights to the server
and databases. Per the BOL, I explicitly gave the login db_owner rights
to both the distributor and publication databases. Nevertheless, the
LogReader agent fails with the following error message:

Executed as user: mydom\sqldev. A required privilege is not held by the
client. The step failed.

The SQLAgentManger on each of the three boxes also runs with the sqldev
ID. Anybody have any idea what the "required privilege" is that the
LogReader agent is missing?

Any help greatly appreciated.

Randy

May 12 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.