May 24, 2018 at 10:26 am
Hi,
unable to start the SQLServer Agent service .
This service Log on as --- NT Service\SQLSERVERAGENT
Agent XPs is disabled .So when ever i tried to configure option 'Agent XPs' from 0 to 1. its automatically changes from 1 to 0 and sqlserver agent is not starting.
SQL Version is :
Microsoft SQL Server 2016 (SP2) (KB4052908) - 13.0.5026.0 (X64) Mar 18 2018 09:11:49 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows Server 2016 Standard 10.0 <X64> (Build 14393: ) (Hypervisor)
Any succession please.
Thank you !!
May 24, 2018 at 12:26 pm
Anything in the SQL Server Agent Error Log? That should tell you why it failed to start.
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
May 24, 2018 at 3:31 pm
What Edition of SQL Server? If you installed the Express Edition - that does not support SQL Server Agent and the service will not start.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply