Sql Server Agent service not starting because the Agent XPs is disabled. How to solve this problem?
0
votes
2
answers
136
views
I have a bunch of servers hosted in Canada,
one of them has some erratic behaviour when under too much pressure for some time.
it just looses connectivity as probably the CPU is on high.
this is beyond the point of this question here, just explaining a little bit of the background.
What becomes relevant is that when they reboot the box it starts to work fine again.
Now the concern:
After the box is rebooted the sql server agent does not get started.
The reason why the sql server agent does not get started is because of “Agent XPs disabled” error
On the above link, there are pictures and those match the situation I see on my rogue server.
After I manually enable the
SQL Server Agent should not be in the windows admin group. but I wonder what permission might be missing so that the Agent XPs can be re-enabled and our sql server agent can be started?
I have NOT Set the SQL Agent service to Automatic(Delayed)
SQL Browser service is running.
I see this in the error log:
The current event was not reported to the Windows Events log. Operating system error = (null). You may need to clear the Windows Events log if it is full.
That took me to have a look at this:
> The “Configure log access” policy under “Computer Configuration” ->
> “Administrative Templates” -> “Windows Components” -> “Event Log
> Service” -> “Application” is enabled. You can check this policy by
> running gpedit.msc.
and this is the current settings for that:
For the

Agent XPs
and start manually the sql server agent then all works. But I don't want to manually start it. Why is it not starting on its own?
Running this query I can see the status of Agent XPs and Show Advanced Options :
use master
go
select * from sys.configurations where name in ('Agent XPs','Show advanced options')


startup options set to for the service
nothing outstanding.
Asked by Marcello Miorelli
(17274 rep)
May 29, 2025, 10:56 AM
Last activity: Jun 9, 2025, 02:19 PM
Last activity: Jun 9, 2025, 02:19 PM