SQL Server Agent can't start

[Former Member]

Hi Expert,

I have a problem when using SQL Server 2005.

I also use Windows Server 2008

My SQL Server Agent can't start.

When I try to start, I have message "The SQL Server Agent (MSSQLSERVER) service on Local Computer started and then stopped (object explorer).

Why does this problem happen?

Thanks

Regards,

Vicky Oktavianus

[markus_doehr2]

> My SQL Server Agent can't start.

> When I try to start, I have message "The SQL Server Agent (MSSQLSERVER) service on Local Computer started and then stopped (object explorer).

...and also check the Windows event log.

Markus

[clas_hortien]

Hi,

send us the sqlagent.out file, that can be found in the LOG directory of your SQL Server installation.

Best regards

Clas

[Former Member]

Hi Clas,

I want to send sqlagent.out file, but where I can upload that file?

thanks for your help

Vicky

[Former Member]

Hi Clas,

This is what I get from sqlagent.out file

2010-08-16 15:28:21 - ! [241] Startup error: Unable to initialize error reporting system (reason: The EventLog service has not been started)

2010-08-16 15:28:21 - ? [098] SQLServerAgent terminated (normally)

Thank You

[clas_hortien]

Have you started the Windows Eventlog Service ? Please check the services on the local machine, if the service is running.

Can you browse the event log, using the Windows Eventviewer (eventvwr.exe) ?

[markus_doehr2]

> 2010-08-16 15:28:21 - ! [241] Startup error: Unable to initialize error reporting system (reason: The EventLog service has not been started)

> 2010-08-16 15:28:21 - ? [098] SQLServerAgent terminated (normally)

You seem to have an issue with your machine, I suggest you check further up in the event log for problems concerning the event log.

Uploading files here is not possible, open an OSS call (component BC-DB-MSS) and ask the support for help, there you can upload the file.

Markus