A required privilege is not held by the client. The step failed. – SQL Job Fails with error – Solution

I was aware of the best practice to use SQL Server Configuration Manager instead of using MMC Console but faced this error for not following the best practice.

Well, I had to change the Logon account of my SQL Server and SQL Agent, used Windows MMC console to change and restarted the services. After some time, I noticed SQL replication jobs started failing with the error .

Solution: I tried to manually add required permissions on Server groups but this did not solve the problem. Followed 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

This resolved the problem, replication started working as expected.

Why: When SQL Server Configuration Manager provides appropriate permissions at multiple levels! Make sure to use SSCM (SQL Server Configuration Manager to manage SQL Server)

Reference: http://support.microsoft.com/kb/911305

-Vijred

This entry was posted in SQL, SQL Error, Windows Server and tagged , , , . Bookmark the permalink.

Leave a comment