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

sql-server-2014
user4090029 picture user4090029 · Mar 28, 2015 · Viewed 88k times · Source

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:

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: 

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!

Answer

H. Aydin picture H. Aydin · Sep 3, 2015

If you are running SQLEXPRESS, then SQLAGENT doesn't run. If you are running SQL2008 OR SQL2012, probably you changed SQL SA password. You can change SQL Service authentication from Network Service to Local System, then Start the service manually.

Related questions

SQL Server after update trigger

I have a problem with this trigger. I would like it to update the requested information only to the row in question (the one I just updated) and not the entire table. CREATE TRIGGER [dbo].[after_update] ON [dbo].[MYTABLE] …

Read More
Partition Function COUNT() OVER possible using DISTINCT

I'm trying to write the following in order to get a running total of distinct NumUsers, like so: NumUsers = COUNT(DISTINCT [UserAccountKey]) OVER (PARTITION BY [Mth]) Management studio doesn't seem too happy about this. The error disappears when I remove …

Read More
How do I create a local database inside of Microsoft SQL Server 2014?

Forgive me if this question was already asked before. I just installed Microsoft SQL Server Management Studio 2014. I want to create a database so I can start building some tables from scratch. All I am getting is the ability to …

Read More