I cannot start the SQL Server agent regardless of who I'm logged on as (even as domain admins).

07/04/04 11:39:03 - ? [129] SQLServerAgent starting under Windows NT service control
07/04/04 11:39:03 - ! [298] SQLServer Error: 18456, Login failed for user 'RSC\Administrator'. [SQLSTATE 28000]
07/04/04 11:39:03 - ! [000] Unable to connect to server; SQLServerAgent cannot start
07/04/04 11:39:03 - ? [098] SQLServerAgent terminated (normally)

Anybody got any ideas. I've already checked the port...

Its SQLServer 7 on Windows NT

Lisa

were any passwords changed?

frazzled is correct, you are seeing this because the password for the 'RSC\Administrator' has changed. Go into services, double click sql server agent and change the password to what the new password is. If you do not need the agent to access network drives I'd suggest having it log on as the local system account. Otherwise create a domain user with lower privilages than the administrator account.

BTW, This is a pervasive forum, not a Sql Server forum.

Hope this helps,
Eric

You may solve this problem by assigning user rights to the user: "NT AUTHORITY\SYSTEM".
Follow these steps:
Open "SQL Server Management Studio".
Open "Security, and then Logins".
Rightclick on user: "NT AUTHORITY\SYSTEM >> Properties".
Select "Server Roles" tab, and check the "sysadmin" server role.
You are done. SQL Server Agent will be started now.