Troubleshooting Replication Error: A required privilege is not held by the client

Written by belle
Posted April 25, 2011 at 2:35 pm

If you ever you encounter this replication issue, the resolution might be fairly simple, however it will require that you toggle your SQL Service accounts.

Have a look at this KB:
http://support.microsoft.com/kb/911305/en-us

The KB suggests the service account might have changed using a tool other than the Configuration Manager (technically a no-no because the SSCM, in addition to changing the service accounts, also performs updates to associated settings like windows registry entries). Try toggling the service accounts in Configuration Manager (for ex, from Administrator, to something Local, to administrator again) and that should flush the old credentials.

Quote from KB:

”
To resolve the problem, follow these steps:

1. Set the SQL Server Agent service account in SQL Server Configuration Manager to the LocalSystem account.
2. Stop and then start the SQL Server Agent service.
3. Reset the SQL Server Agent service account in SQL Server Configuration Manager back to the original account.
4. Stop and then start the SQL Server Agent service.

”

Good luck!

Rating: 8.5/10 (2 votes cast)

Rating: 0 (from 0 votes)

Troubleshooting Replication Error: A required privilege is not held by the client, 8.5 out of 10 based on 2 ratings

Be Sociable, Share!