opc.three (2/19/2013)
I do not think you need to add anyone to the sysadmin Role for this. Per the article you just need to add the service account you decide to use to start the SQL Agent service to the SQL Server Agent local group. On my machine that group is named...SQLServerSQLAgentUser$MYCOMPUTERNAME$SQL2008R2DEV
...where MYCOMPUTERNAME is my computer name and SQL2008R2DEV is my instance name.
Sorry for bugging you again, but I'm still struggling with this. The IT admin is not finding any SQL Server Agent local group or any group with a similar name to SQLServerSQLAgentUser$MYCOMPUTERNAME$SQL2008R2DEV.
This is on a Windows 2008 Server, is that the difference here?
The article has a different solution which mentions:
Step 2: Add the SQL Server Agent service security principal as a system administrator for SQL Server 2008
Note The service security principal is named "NT SERVICE\MSSQLSERVER" for default instances and is named "NT SERVICE\SQLAGENT$Instance Name" for named instances.
I do have this user as a sysadmin. Is this the user that should be used for the SQL Server Agent "Log on as"? How would I know what password this user has?