Link to home
Start Free TrialLog in
Avatar of Ja Che
Ja Che

asked on

SQL 2005 required privilege is not held by the client

Hello, I have jobs that use a domain account to run hourly and nightly.

I'm receiving the following error - reason: A required privilege is not held by the client.

I've already tried this KBA from Microsoft - https://support.microsoft.com/en-us/kb/911305

How can I resolve this?

Thank you!
Avatar of Darrell Porter
Darrell Porter
Flag of United States of America image

Does the domain account in question have the appropriate permissions within SQL as well as on the local SQL server?

For SQL 2005, please refer to this document for the required permissions.
Avatar of Ja Che
Ja Che

ASKER

Which permissions specifically are you referring to? I think so, as this was the same account that was being used previously for the SQL Server Agent.

The only thing I've changed recently is the domain admin account used to create the job in SQLMS.
ASKER CERTIFIED SOLUTION
Avatar of Anthony Perkins
Anthony Perkins
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial