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

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s