How to fix error "SQL Server Agent stopped automatically"?

Question

0.00/5 (No votes)

See more:

SQL-Server-2014

Hi. I'm using SQL Server 2014 and having a problem.

In Task Manager, on Services tab, I found SQLAgent$VILLBE_SQLSERVER (VILLBE is my computer name), right click and Start.

It started and... stopped after 1 second.

Then, I open services.msc, and Start the SQL Server Agent (VILLBE_SQLSERVER). It's working.

After 30 seconds, it stopped automatically. When I click Start again, it said that:

HTML

The SQL Server Agent (VILLBE_SQLSERVER) service on Local Computer started and then stopped. Some services stop automatically if they are not in use by other services or programs.

Last, I right click SQL Server Agent, choose Properties, set Start up type is Automatic and reboot my PC.

When reboot is done, SQL Server Agent still is stopped

Some other services:

HTML

SQL Server Browser - Running - Automatic (start up)
SQL Server (SQLEXPRESS) - Cannot start within warning: Windows could not start the SQL Server (SQLEXPRESS) on Local Computer....error code 17058.

Can you give me anyway to fix the problem?

Thank you!

Posted 28-Mar-15 3:54am

user8x86

Updated 6-Feb-18 19:20pm

Add a Solution

Comments

Maciej Los 28-Mar-15 13:11pm

Are you sure you have MS SQL server installed?

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

phil.o · Answer 1 · 2015-03-28T07:07:00

Try to setup a maintenance plan, for example. This will give your agent something to do.
It may be that the service does not run because nothing at all is given to do to it.
It can also be that you are using an express version of SQL Server, which does not support the use of an agent. Silly that it is installed anyway, but that's a fact.

Maciej Los · Answer 2 · 2015-03-28T07:12:00

Solution 2

As is described here: http://dba.stackexchange.com/questions/55485/windows-could-not-start-the-sql-server-mssqlserver-service-on-local-computer-e[^] it seems to be permission error.

Posted 28-Mar-15 7:12am

Maciej Los

KK shah · Answer 3 · 2018-02-06T19:20:00

Solution 3

step 1:- start Windows Event Log service
step 2:- try to start sqlserveragent service it will work

Posted 6-Feb-18 19:20pm

KK shah