SQL Server Agent no longer starting
-
Our sql server is running fine for several years, suddenly the SQL Agent does not start anymore.
On 08-06-2007 the agent dies with the event:
Event ID: 7034, The SQLSERVERAGENT service terminated unexpectedly. It has done this 1 time(s).
I can't find any logging concerning this crash.
If I start the Agent I get two messages in the eventlog:
Eventid: 7009, Timeout (30000 milliseconds) waiting for the SQLSERVERAGENT service to connect.
Event ID: 7000, The SQLSERVERAGENT service failed to start due to the following error:
The service did not respond to the start or control request in a timely fashion.
In SQLAgent.out these are the last entries:
2007-08-06 01:00:00 - ? [177] Job Integrity Checks Job for DB Maintenance Plan 'DB Maintenance daily' has been requested to run by Schedule 2 (Schedule 1)
2007-08-06 01:01:49 - ? [184] Job completion for Integrity Checks Job for DB Maintenance Plan 'DB Maintenance daily' is being logged to sysjobhistory
2007-08-06 01:08:53 - ? [248] Saving NextRunDate/Times for all updated job schedules...
2007-08-06 01:08:53 - ? [249] 1 job schedule(s) saved
2007-08-06 03:00:00 - ? [177] Job Optimizations Job for DB Maintenance Plan 'DB Maintenance daily' has been requested to run by Schedule 3 (Schedule 1)
2007-08-06 03:03:36 - ? [184] Job completion for Optimizations Job for DB Maintenance Plan 'DB Maintenance daily' is being logged to sysjobhistory
2007-08-06 03:08:54 - ? [248] Saving NextRunDate/Times for all updated job schedules...
2007-08-06 03:08:54 - ? [249] 1 job schedule(s) saved
2007-08-06 04:00:00 - ? [177] Job DB Backup Job for DB Maintenance Plan 'DB Maintenance daily' has been requested to run by Schedule 7 (Schedule 1)
2007-08-06 04:17:11 - ? [184] Job completion for DB Backup Job for DB Maintenance Plan 'DB Maintenance daily' is being logged to sysjobhistory
2007-08-06 04:28:54 - ? [248] Saving NextRunDate/Times for all updated job schedules...
2007-08-06 04:28:54 - ? [249] 1 job schedule(s) saved
2007-08-06 18:00:00 - ? [177] Job Camperverhuur - Email biedingen has been requested to run by Schedule 9 (Camperverhuur - emailbiedingen)
2007-08-06 18:00:00 - ? [184] Job completion for Camperverhuur - Email biedingen is being logged to sysjobhistory
2007-08-06 18:09:00 - ? [248] Saving NextRunDate/Times for all updated job schedules...
2007-08-06 18:09:00 - ? [249] 2 job schedule(s) saved
2007-08-06 18:30:00 - ? [177] Job Motoronderdelenlijn - Email biedingen has been requested to run by Schedule 8 (Dagelijks)
2007-08-06 18:30:00 - ? [184] Job completion for Motoronderdelenlijn - Email biedingen is being logged to sysjobhistory
2007-08-06 18:49:00 - ? [248] Saving NextRunDate/Times for all updated job schedules...
2007-08-06 18:49:00 - ? [249] 1 job schedule(s) saved
2007-08-07 01:00:00 - ? [177] Job Integrity Checks Job for DB Maintenance Plan 'DB Maintenance daily' has been requested to run by Schedule 2 (Schedule 1)
Can anybody help me with this riddle ?
Machiel Broekman
ISES Softpack
-
1. Have you changed the MSSQLServer startup account &.or password?
2. Does the SQL Server login BUILTIN\Administrators exist? If so, does it
have master as the default database and sysadmin privileges if no please do grant it.
3.Did you update your server or register any new dll or installed any new software ?
Please read the below link :
http://support.microsoft.com/kb/282254/en-us
Minaz
"More Green More Oxygen !! Plant a tree today"
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply