October 3, 2013 at 4:34 am
Hi
I am not bale to start Server agent after server restart( Sql Server 2012) .
It is giving me the following error .
"The service did not respond to the start or control request in a timely fashion .[0x8007041d]"
Can anyone help pls.
Gita
October 3, 2013 at 4:42 am
can you give us more detail about this problem.
sql error log, sql server entries from event viewer
October 3, 2013 at 4:47 am
Sql Server event log added below
Date,Source,Severity,Message
10/03/2013 12:26:58,,Information,[098] SQLServerAgent terminated (normally)
10/03/2013 12:26:58,,Information,[000] Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install. [SQLSTATE 01000] (Message 15457) Configuration option 'Agent XPs' changed from 1 to 0. Run the RECONFIGURE statement to install. [SQLSTATE 01000] (Message 15457) Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install. [SQLSTATE 01000] (Message 15457)
10/03/2013 12:26:56,,Information,[131] SQLSERVERAGENT service stopping due to a stop request from a user<c/> process<c/> or the OS...
10/03/2013 12:23:53,,Warning,[180] Job cdc.Chevron_POC_capture was deleted while it was executing: the outcome was (Unknown)
09/30/2013 15:43:53,,Warning,[396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect
09/30/2013 15:43:53,,Warning,[475] Database Mail is not enabled for agent notifications.
09/30/2013 15:43:52,,Information,[129] SQLSERVERAGENT starting under Windows NT service control
09/30/2013 15:43:52,,Error,[364] The Messenger service has not been started - NetSend notifications will not be sent
09/30/2013 15:43:35,,Information,[432] There are 7 subsystems in the subsystems cache
09/30/2013 15:43:35,,Information,[339] Local computer is ITSDEV10 running Windows NT 6.1 (7601) Service Pack 1
09/30/2013 15:43:35,,Information,[310] 4 processor(s) and 8192 MB RAM detected
09/30/2013 15:43:35,,Information,[103] NetLib being used by driver is DBNETLIB; Local host server is
09/30/2013 15:43:35,,Information,[102] SQL Server ODBC driver version 11.00.3000
09/30/2013 15:43:35,,Information,[101] SQL Server ITSDEV10 version 11.00.3000 (0 connection limit)
09/30/2013 15:43:35,,Information,[000]
09/30/2013 15:43:34,,Information,[393] Waiting for SQL Server to recover database 'msdb'...
09/30/2013 15:43:34,,Information,[495] The SQL Server Agent startup service account is NT Service\SQLSERVERAGENT.
09/30/2013 15:43:34,,Information,[100] Microsoft SQLServerAgent version 11.0.3000.0 (X64 unicode retail build) : Process ID 1704
October 3, 2013 at 12:03 pm
*- is the agent have its own service account?
*- any service packs / windows updates were applied
*- could you paste the errors recorded in the error log. (Default location Program Files\Microsoft SQL Server\MSSQL.n\MSSQL\LOG\ERRORLOG and ERRORLOG.n)
October 4, 2013 at 7:15 am
hi,
have you ever read this:
http://grumpydba.blogspot.de/2012/09/sql-2008-r2-reporting-services-wont.html
the services need maybe more time for respond. and with this link, you can set up the time for service to respond.
let me know it this was helpful...
October 4, 2013 at 7:55 am
I've seen this when my service account loses it's "Log on as service" rights.
Might be something to check - could temporarily change the Agent service to use Local System account to see if it will start to see if it is actually the service account which is the problem (assuming you are using one) - then go fix the service account....
October 4, 2013 at 8:23 am
SQLSERVERAGENT service stopping due to a stop request from a user<c/> process<c/> or the OS...
Maybe check the windows event log?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 5, 2013 at 12:28 am
Yes it was the issue with the service account . Fixed it . Thank you all for the help.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply