SQL2000 - SQLSERVERAGENT kan ikke starte
HejsaMin SQLSERVERAGENT på en Windows 2003 server vil ikke starte.
Når jeg starter servicen fra services får jeg følgende fejl:
The SQLSERVERAGENT service on local computer started and then stopped. Some services stop automatically if they have no work to do, for example, the performance logs and alerts service.
Når jeg kigger i min event viewer kan jeg se følgende fejl:
SQLServerAgent could not be started (reason: Unable to connect to server '(local)'; SQLServerAgent cannot start).
Når jeg kigger i min log SQLAGENT.OUT kan jeg se:
2008-08-28 20:54:32 - ! [298] SQLServer Error: 18456, Login failed for user 'NT AUTHORITY\SYSTEM'. [SQLSTATE 28000]
2008-08-28 20:54:32 - ! [000] Unable to connect to server '(local)'; SQLServerAgent cannot start
2008-08-28 20:54:33 - ? [098] SQLServerAgent terminated (normally)