HiveBrain v1.2.0
Get Started
← Back to all entries
debugsqlMinor

SQL Server Agent won't start

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
serversqlagentstartwon

Problem

When I'm trying to start SQL Server Agent, I got this error:


TITLE: Microsoft SQL Server Management Studio

Unable 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 'NAGA\SQL_NAGA'; SQLServerAgent cannot start).


UPDATE:

Error log of SQL Server Agent

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

Solution

Set the SQL Agent service to Automatic(Delayed). The first thing it will do is try to connect to SQL Server, and if SQL Server hasn't finished starting yet, SQL Agent can fail. Delaying the start for SQL Agent will give SQL Server the chance to finish.

Context

StackExchange Database Administrators Q#127864, answer score: 2

Revisions (0)

No revisions yet.