Sql Server Agent (SQLEXPRESS) on local computer started is stopped?

Navigation
1

Hello, I have a machine with windows 10

I installed SQL Server normally, it was working, but now SQL Server does not start, I went to the service manager and when I try to boot I get the message:

The Sql Server Agent (SQLEXPRESS) service on Local Computer has started is stopped. Some services are automatically stopped if they are not being used by other services and programs

    
asked by anonymous 01.09.2015 / 21:52

3 answers

0

Good,

The SQL Server Agent (SQLExpress) is not the primary service of SQL Server . You should start the SQL Server (SQLExpress) service that is quite different from the Agent .

The SQL Server Agent is responsible for proactive SQL Server tasks. That is, any scheduled operation of SQL Server to run in a certain period (eg: Backups) is managed by the Agent. The Agent will never boot if normal SQL Server is not started. Which means that it is not this service that you should start, but rather what I indicated to you. If it is not successful, I recommend that you check the operating system's Event Viewer.

Possible causes:

  • Your windows may be overloaded at startup;
  • Your SQL Server may have a very heavy Database which combined with the startup of windows may result in another overload;
10.11.2015 / 09:58
0

This problem occurs in non-English versions of Windows.

In the directory where the service is located, open the "SQLScheduler.WindowsService.exe.config" file. In it, look for the "authorizedGroup" attribute and change from "everyone" to "all". Start the service normally.

I hope I have helped!

Fábio Rocha

    
10.11.2015 / 05:37
-1

SQL Server Agent does not work in Express Editions of SQL Server. Although the service appears as installed, it can never be activated. This is in the SQL Server Editions supported features .

    
31.10.2016 / 10:43
Connection Error with the Database in ANDROID How to get distance given the coordinates using SQL?