Is Sql Server Agent (SQLEXPRESS) on Local Computer started stopped?

Asked

Viewed 7,027 times

2

Hello, I have a machine with windows 10

I did the installation of SQL Server normally, it was working, only now SQL Server does not start, I went to the service manager and when trying to boot I have the message:

The Sql Server Agent (SQLEXPRESS) service on your local computer was started is stopped. Some services are automatically stopped if not being used by other services and programs

sql-server

  • I have the same problem :

  • Here’s what my friend... i don’t know but every time that stick and I enable all protocols there in SQL Server Configuration Manager and open the Services in administrator mode..

3 answers

1


Good,

The SQL Server Agent (Sqlexpress) is not the main service of SQL Server. You must start the service SQL Server (Sqlexpress) which is quite different from Agent.

The SQL Server Agent is responsible for proactive SQL Server tasks. That is, every scheduled SQL Server operation to run in a given period (e.g., Backups) is managed by the Agent. The Agent will never start if the SQL Server normal is not initiated. Which means it’s not this job you’re supposed to start, it’s what I told you. If you are unsuccessful, I recommend you to check the operating system’s Event Viewer.

Possible causes:

  • Your windows may be overhead on startup;
  • Your SQL Server may have a very heavy database which combined with the startup of windows, may result in another overcharge;

-1

This problem occurs in non-English versions of Windows.

In the directory in which the service is located, open the file "Sqlscheduler.WindowsService.exe.config". In it, look for the attribute "'authorizedGroup" and change from "Everyone" to "all". Start the service normally.

I hope I’ve helped!

Fábio Rocha

-2

SQL Server Agent does not work in SQL Server Express editions. Although the service is listed as installed, it can never be activated. That’s in the documentation Features supported in SQL Server editions.

Browser other questions tagged sql-server

You are not signed in. Login or sign up in order to post.