SQL Server Agent(Agent XPs disabled)

I've an issue with SQL Server Agent which is disabled and I'm trying to enable but it won't work.

I've used following steps. Can someone guide me? Thank you reading and helping me.

STEP.1 EXEC SP_CONFIGURE 'Agent XPs'

STEP.2 EXEC SP_CONFIGURE 'show advanced options',1

GO RECONFIGURE GO EXEC SP_CONFIGURE 'show advanced options' STEP.3 EXEC SP_CONFIGURE 'Agent XPs',1 GO RECONFIGURE
January 8th, 2014 1:24pm

can you try RECONFIGURE WITH OVERRIDE option?

http://technet.microsoft.com/en-us/library/ms176069.aspx

Free Windows Admin Tool Kit Click here and download it now
January 8th, 2014 1:43pm

Try refreshing SQL Server Agent

-Prashanth

January 8th, 2014 1:47pm

Hello Visakh,

Yes I reconfigure with override with following code but still no help.


sp_configure 'show advanced options',1

go

reconfigure with override

go

sp_configure 'Agent XPs',1

go

reconfigure with override

go

sp_configure 'show advanced options',0

go

reconfigure with override

go

 

Free Windows Admin Tool Kit Click here and download it now
January 8th, 2014 2:11pm

Thank you prashanth. Still same issue..
January 8th, 2014 2:12pm

Just a brief question, which edition of SQL Server are you using, is it the Express Edition? SQL Server Agent is not a supported feature of Express, you can't enable it then.
Free Windows Admin Tool Kit Click here and download it now
January 8th, 2014 2:30pm

Olaf,

I've SQL Server 2005 Standard Edition. Error is :- "The request failed or the service did not respond in a timely fashion. Consult the event log or other application error logs for details" 

January 8th, 2014 2:34pm

Did you tried to disable the VIA from the configartion manager sometime it resolves the issue.

http://www.sqlservercurry.com/2009/12/resolving-sql-server-error-request.html

Did you observerd any other error details in SQLagent logs, like access denied?

Free Windows Admin Tool Kit Click here and download it now
January 8th, 2014 8:46pm

Is your SQL Agent service running?

 EXEC xp_servicecontrol N'QUERYSTATE','SQLSERVERAGENT' --default instance

or

 EXEC xp_servicecontrol N'QUERYSTATE','SQLAgent$[instance name]' --named instance


January 8th, 2014 8:53pm

Olaf,

I've SQL Server 2005 Standard Edition. Error is :- "The request failed or the service did not respond in a timely fashion. Consult the event log or other application error logs for details" 

As the message says did you consulted event logs for more details,Can you tell message listed in event viewer
Free Windows Admin Tool Kit Click here and download it now
January 9th, 2014 5:35am

Check the SQL Agent Services account is still working or not.

Refer the below link,

http://stackoverflow.com/questions/1617402/the-request-failed-or-the-service-did-not-respond-in-a-timely-fashion

http://blog.sqlauthority.com/2011/03/29/sql-server-fix-error-the-request-failed-or-the-service-did-not-respond-in-timely-fashion-consult-the-event-log-or-other-applicable-error-logs-for-details/

January 9th, 2014 5:50am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics