What must I do when SQL Server Agent won't start?
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).
If SQL Server Agent won’t start, Check if the service is running. If not you can start the service using one of these alternatives:
services.msc
net start SQLSERVERAGENT
Using SQL Server Configuration Manager
Windows service manager start SQL Agent service (automatic)
If the service is running, you can try this:
--------------------------------------------------------------------- -- Start SQL Server Agent when ‘Agent XPs disabled’ --------------------------------------------------------------------- EXEC sp_configure 'show advanced options', 1 GO RECONFIGURE GO EXEC sp_configure 'Agent XPs', 1 GO RECONFIGURE GO --------------------------------------------------------------------- --http://zarez.net/?p=2720 ---------------------------------------------------------------------
Course: SQL