I need to idenitfy a list of "Sufficient Privileges" to my admin team to the SQL Server Agent Service account. We created a new user group, however I am getting an error when I change the Agent account details: "Please provide an account with administrator privileges". My admin tells me that this defeats the entire purpose of what we are trying to do with the policies on this account. We want the minimal amount of privileges available to run all the jobs assigned the server. Any ideas?
Start Free Trial