sql server agent problem

[\Allen Iverson\]

Hi,

I cannot start the sql serveragent at all. First, it won't
start after I set it up as auto-start service and after I reboot the server.
The event log said:

SQLServerAgent could not be started (reason: Unable to
connect to server '(local)'; SQLServerAgent cannot start).

It won't start even when I do it manually. Please help.
Thanks.

 

[Hari Prasad]

Hi,

THis error normally occurs when you remove or revoke permissions from
BUILDIN\ADMINISTRATORS
from SQL Server and if your SQL Agent is running under LOcalsystem account.

Have a look into the Microsoft KB article.

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q237604&ID=KB;EN-US;
Q237604

Note:

Ensure that you start SQL Server and SQl Agent service using the same
Windows account, preferably a Domain user.

Thanks
Hari
MCDBA

 

[Wayne Snyder]

SQL Server Must be running for SQL Agent to start as well.. If you
auto-start SQL Agent, ensure you have SQL Server auto-starting as well.

--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)

I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org