March 17, 2014 at 1:20 pm
i tried to start the agent by enabling the XP's after runing the reconfgiure xp it shows 0 to 1 , later whne i tried to start it goes to 0 . i checked in logs but didnot find any thing , how to start the sql agent.
March 17, 2014 at 2:05 pm
Did you check all logs (event viewer as well), if not errors reported, did you just run RECONFIGURE or did you specify RECONFIGURE WITH OVERRIDE?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 17, 2014 at 2:28 pm
specified reconfigure
March 17, 2014 at 3:28 pm
Is it possible you had a typo somewhere? Please see this article for a similar issue
http://www.sqlservercentral.com/Forums/Topic465265-149-1.aspx
If the Agent can't start, the reason for it is logged in the OUT file, check your settings to find out where this error log file is located and post it here for us to review (Ref: (http://social.msdn.microsoft.com/Forums/sqlserver/en-US/542bab08-c8a6-4106-ae96-99bf0f895bd8/cant-start-sql-server-agent-service?forum=sqldatabaseengine)
Also, try using the WITH OVERRIDE sp_configure 'show advanced options','1'
RECONFIGURE
go
sp_configure 'Agent XPs','1'
RECONFIGURE WITH OVERRIDE
go
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply