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