SQL Server 2019, when starting SQL Server Agent, an error message appears: The SQL Server Agent (MSSQLSERVER) service on the local computer started and then stopped. Some services stop automatically when they are not used by other services or programs.

Question

The reason is that when I connected to the database through ssms, I found that there was no "Task Schedule" in "Management", so I could not create an automatic backup plan. I found that the status of the SQL Server Agent service was disabled in Windows Services, and when I tried to start it, the following error was generated.

Answer 1

Hi qixiong Li，

Please first check you edition of the SQL Server, SQL Server Express Edition is a free version that does not include the SQL Agent.

SQL Server Agent has to log on as Local System Account. Open up services console (start > run > type services.msc) and locate "SQL Server Agent" service and double click on it. Go to "Log On" tab and ensure "Local System Account" is selected. After confirming, you should be able to start this service.

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.