What are the things a SQL Server Agent won't start?

167 Asked by CelinaLagunas in Salesforce , Asked on Apr 16, 2021

When I'm trying to start SQL Server Agent, I got this error:TITLE: Microsoft SQL Server Management StudioUnable to start service SQLAGENT$SQL_NAGA on server NAGA. (mscorlib) ADDITIONAL INFORMATION: The SQLAGENT$SQL_NAGA service on NAGA started and then stopped. (ObjectExplorer) Can you guys help me to solve this problem? I'm using 2014 Enterprise Edition.

Using @@version I got this: Microsoft SQL Server 2014 - 12.0.4213.0 (X64) Jun 9 2015 12:06:16 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.3 (Build 10586: ) I also found this error event related to SQL Server Agent in the Windows Event Log Log Name: Application Source: SQLAgent$SQL_NAGA Date: 1/31/2016 6:17:24 PM Event ID: 103 Task Category: Service Control Level: Error Keywords: Classic User: N/A Computer: Naga Description: SQLServerAgent could not be started (reason: Unable to connect to server 'NAGASQL_NAGA'; SQLServerAgent cannot start).

UPDATE:

Error log of SQL Server Agent

enter image description here

SQL Server and SQL Server Agent both logged on as Local System Account

enter image description here

Answered by Daniel Cameron

If you are facing sql server agent won't start error would be where I would start looking: SQLServer Error: 27, Registry information is corrupt or missing. Make sure the provider is installed and registered correctly. If you are able to perform a repair of the installation, that should resolve this. Hope this helps!

What are the things a SQL Server Agent won't start?

Your Answer