SQLAGENT CAN'T START

Error message in the event log:

 

SQLServerAgent could not be started (reason: SQLServerAgent must be able to connect to SQLServer as SysAdmin, but '(Unknown)' is not a member of the SysAdmin role).

Resolution:

Agent XPs wasn't enabled...

So need to enabled it using this script:


sp_configure 'show advanced options', 1;
GO
 RECONFIGURE;
GO
sp_configure 'Agent XPs', 1;
GO
 RECONFIGURE
GO