Can't start the SQLAGENT service

Hi Guru,
I'm tired of trouleshoot one of my sql box that the sqlagent can't started.
Here is the message:
SQLServerAgent could not be started (reason: Unable to connect to server '
(local)'; SQLServerAgent cannot start)
? SQLSERVER runs on LocalSystem account with started up type automatic and
successful
? Connect to SQL Analyzer: LocalHost, . (period), (local) and blank all
successful
? Registry key and MDAC are good safe
? BUILTIN\Administrators is present and SYSADMIN rights
? From AD, domain accounts passwords are in synch.
? Win2000, SQL2000 SP3a and build 800.00.760
? Client and network utility used both name pipe and TCP
From enterprise manager on the server itself, I am able to register the
server by supplying the server name. However, when I tried to register with
the (local), I was never able to do so.
I also tried to restart the SQL agent with localsystem, domain and local
admin accounts none of them can start the service. These accounts are local
admin to the box and have complete sysdmin rights to sql server. From query
analyzer, these accounts can connect to server with blank, LocalHost, (local),
and period. So, this tells me that the server does not experience of
resolving (local) connection.
I tried to log on to the server with both local and domain accounts to start
agent but nothing is good for me. I tried to change startup account from
enterprise manager to make sure security is in synch but still the same.
However, the last thing that I?ve not done is reboot the OS.
Please help,
Thanks,
Silaphet,
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200605/1(local) only works on the default instance. Are you trying to connect
to a named instance?|||can you check whats the exact message in SQLAGENT.OUT

Can't start SQLServerAgent

All of sudden, getting a Dr. Waston error with illegal
instruction on boot up.
If I tried to start it from the Services menu, get "Could
not start the SQLServerAgent service on \\server_name
Error 1067: The process terminated unexpectedly"
Do I need to reload the software... I have not found any
help in the Knowledge baseTake a closer look at the Dr Watson log to see if the SQLAgent service is
generating the Dr Watson error.
Stop any unnessary services on the machine. Leave the following running:
- Alerter
- Computer Browser
- Event Log
- License Logging Service
- Messenger
- Net Logon
- NTLM Security Support Provider
- Network Connectors
- Plug and Play
- Remote Procedure Call (RPC) Locator
- Remote Procedure Call (RPC) Service
- Server
- Spooler
- TCP/IP NetBIOS Helper
- Time Service
- Workstation
Review the NT application & System logs for hardware failure errors.
Test to see if you can start SQL Server from a command prompt.
If the problem persists and you're on the latest service pack, sp3, then
you should open up a support case.
If the Dr Watson is being caused by a bug in our product you will not be
charged for the incident.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Can't start SQLServerAgent

All of sudden, getting a Dr. Waston error with illegal
instruction on boot up.
If I tried to start it from the Services menu, get "Could
not start the SQLServerAgent service on \\server_name
Error 1067: The process terminated unexpectedly"
Do I need to reload the software... I have not found any
help in the Knowledge base| All of sudden, getting a Dr. Waston error with illegal
| instruction on boot up.
|
| If I tried to start it from the Services menu, get "Could
| not start the SQLServerAgent service on \\server_name
| Error 1067: The process terminated unexpectedly"
|
| Do I need to reload the software... I have not found any
| help in the Knowledge base
--
Folks,
If you can't find references of a SQL exception, please log a case with
Microsoft product support. There is a chance that this a bug so the case
shouldn't cost you.
Hope this helps,
--
Eric Cárdenas
SQL Server support|||Eric,
Thanks for the response... How do I log a case with
Microsoft product support?|||| Eric,
|
| Thanks for the response... How do I log a case with
| Microsoft product support?
|
--
Go to http://support.microsoft.com to get the contact number of Microsoft
product support for your country of residence.
Hope this helps,
--
Eric Cárdenas
SQL Server support