SQL Server Agent Service won't Autostart, eventhough when you right click properties and select => General page, the "Auto restart SQL Server if it stops unexpectedly" and "Auto restart SQL Server Agent if it stops unexpectedly" boxes are checked.
Solution - Navigate - Start -> All Programs -> Microsoft SQL Server 2xxx -> Configuration Tools -> SQL Server Configuration Manager
Select "SQL Server Services" Node in the left pane to see the related SQL Server services in the right pane. Right Click on the "SQL Server Agent (INSTANCE)" under "Name" in Right pane and select "Properties". Go to "Service" tab, check and edit the setting against "Start Mode" parameter. This should fix the issue.
