SQLServerAgent is not currently running so it cannot be notified of this action

Question

This is for very first time that I am trying to use SQL server Agent. I get this error :

Msg 22022, Level 16, State 1, Line 0
SQLServerAgent is not currently running so it cannot be notified of this action.

I went to services to check if it was running. I tried to start it and got this immediately . The services then stopped ofcourse.:

Then I tried with SQL server configuration manager:

On trying to start the service there,

When I try to change the log on account via SQL server configuration manager:

How do I get this service started ?

Answer 1

It can happen as well that you have SQL Service Agent installed on your server with the database, but as the message says it is not running.

Go to Control Panel -> Administrative Tools -> Services and check if service SQL Service Agent is running.

Answer 2

The SQL Server Express editions does not include the SQL Server Agent component. If you want that you need to use any of the versions that includes it (Enterprise, Business Intelligence, Standard or Web).

Reference: Features Supported by the Editions of SQL Server 2014 (the same limits applies to earlier editions too).