Hi Csaba,

quote:

---

We have a Win2000 server (SP2) with SQL Server 2000 (SP3). The SQL Server service is running fine without any problem but recently the SQL Server Agent could not be started.

There's the following error in the Event log:

"The SQLSERVERAGENT service terminated unexpectedly."

This is the content of the latest Agent log (from ...\MSSQL\Log dir):

2003-06-20 09:11:39 - ? [100] Microsoft SQLServerAgent version 8.00.760 (x86 unicode retail build) : Process ID

2003-06-20 09:11:39 - ? [100] Microsoft SQLServerAgent version 8.00.760 (x86 unicode retail build) : Process ID 2108

2003-06-20 09:11:39 - ? [101] SQL Server APRO-SZERVER version 8.00.760 (0 connection limit)

2003-06-20 09:11:39 - ? [102] SQL Server ODBC driver version 3.81.9031

2003-06-20 09:11:39 - ? [103] NetLib being used by driver is DBMSSHRN.DLL; Local host server is

2003-06-20 09:11:39 - ? [310] 2 processor(s) and 512 MB RAM detected

2003-06-20 09:11:39 - ? [339] Local computer is APRO-SZERVER running Windows NT 5.0 (2195) Service Pack 2

Does anybody has an idea? What could be the problem? How can I get more detailed info about the error?

---

Frank