June 2, 2016 at 2:19 pm
Microsoft SQL Server 2012 (SP3-CU1) (KB3123299) - 11.0.6518.0 (X64)
Jan 7 2016 14:39:01
Copyright (c) Microsoft Corporation
Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (Hypervisor)
We lost our SQL Agent service after a reboot. Looking in either Services or SQL Server Configuration Manager, the SQL Agent service is not shown. Jobs we attempt to start generate an error. Note this is not the express edition, everything was fine last week.
SQLAGENT.OUT file shows the service shutting down prior to the reboot.
I attempted to manually start the service:
"F:\Instances\MSSQL11.CRM\MSSQL\Binn\sqlagent.exe" -i CRM
And that returned:
StartServiceCtrlDispatcher failed (error 0). (note I have already verified this is not the log path error found with error 6)
SQLAGENT.OUT did not change, it still shows the shutdown.
Windows log file shows the StartServiceCtrlDispatcher failed (error 0). but nothing else
Running SQL Server Installation Repair option had no affect, the service is still gone. Install log shows success.
What gives? Any idea on how to get it back?
June 3, 2016 at 9:55 am
is your sql server part of cluster or it is standalone server.
June 6, 2016 at 10:17 am
Update:
We are reinstalling the SQL instance. I did have a go at creating the SQL Agent service manually using SC.EXE, even got it to appear in SQL Configuration Manager(!) but the service wouldn't start. From what I can tell the service got deleted, but I did not find a log event for that.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply