question

Dushyant2426 avatar image
Dushyant2426 asked

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
sql-server-2005
4 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Shawn_Melton avatar image Shawn_Melton commented ·
What Edition of SQL Server? What error(s) are you getting?
0 Likes 0 ·
Dushyant2426 avatar image Dushyant2426 commented ·
Hello Shawn, 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".
0 Likes 0 ·
KenJ avatar image KenJ commented ·
Sounds like you should start the SQL Agent service, first.
0 Likes 0 ·
ThomasRushton avatar image ThomasRushton ♦♦ commented ·
What do the error / event / application logs say?
0 Likes 0 ·

1 Answer

·
ASHOK 1 avatar image
ASHOK 1 answered
check the sql server agent account need to add to admin group then restart the server Hope it will work..
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.