About this question
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 SQL AGENT$SQL_NAGA service on NAGA started and then stopped. (ObjectExplorer)
Can you guys help me to solve this problem? I'm using the 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
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).