Access is denied. [0x80070005] When Changing Sql Server Agent Login

Trying to change the sql server agent to run as a non-admin user, I couldn’t get Sql Server Agent To work without giving it administrator privileges. I got:

---------------------------
WMI Provider Error
---------------------------
Access is denied. [0x80070005]
---------------------------
OK   
---------------------------

You have to grant two privileges – both the Agent User and the MSSQL user.

  • SQLServerSQLAgentUser$bigserver$inst01
  • SQLServerMSSQLUser$bigserver$inst01

One thought on “Access is denied. [0x80070005] When Changing Sql Server Agent Login

  1. Pawel

    For some reason I had the same problem using local non admin accounts. SQL Server should have assigned the permissions but it seems like it didn’t. It helped me to add my agent user to both groups and it finally started. Go figure. I spent hours trying to troubleshoot. This is probably not best practice but at least it works.

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>