We are getting this error in event viewer on one of our SQL 2000 servers:
SQLServerAgent could not be started (reason: Unable to connect to server '(local)'; SQLServerAgent cannot start).
The SQL Server itself is running fine, but the SQLServerAgent refuses to start.
The logon credentials are set to log on as the local administrator, which has logon as service rights, this is the same account that the sql logs in with, so confirmed it's ok.
Any ideas where to even start on this one??
Urgent, hence 500 points.