1

In my machine SQL Server Agent is not expandable with a label (Agent XPs disabled). In this case I run this code to enable it.

sp_configure 'show advanced options', 1;  
GO  
RECONFIGURE;  
GO  
sp_configure 'Agent XPs', 1;  
GO  
RECONFIGURE  
GO  

Then Restart the Agent on SQL server Configuration Manager, it throws this error:

The Request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs for details

When I checked the Windows event log, I saw this error:

Failed to initialize SQL Agent log, The system cannot find the path specified.

What is the resolution?

closed as off-topic by Max Vernon, Marco, Philᵀᴹ, RLF, Andriy M Apr 20 '17 at 6:28

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience. Consider revising your question so that it appeals to a broader audience. As it stands, the question is unlikely to help other users (regarding typo questions, see this meta question for background)." – Max Vernon, Marco, Philᵀᴹ, RLF, Andriy M
If this question can be reworded to fit the rules in the help center, please edit the question.

3

Since we identified it was a permissions issue via the comments, I would suggest you adjust the account running the SQL Agent service to something different if this is a server. Microsoft does a great job to outline the permissions needed for the SQL Agent service account. That article also highlights a few pitfalls regarding some minimal permission grants you want to do so users outside of the sysadmin role can properly utilize Proxy accounts, etc.

If it's your local PC, it likely doesn't matter that you adjust this account nearly as much since that service isn't configured for automatic startup by default.

Glad you got it sorted.

Not the answer you're looking for? Browse other questions tagged or ask your own question.