When attempting to start SQLserveragent service, then servie starts and then stops issuing an informaitonal message "SQLServeragent servie on Local Computer started and then stopped. Some services stop automatically if they have no work to do..."
This prevents the service from running and from starting dependent tasks. The messge is not logged into the event viewer or into the associated error log. The service starts under a local system account and is set how it was previously without issue when running under Win 2000. This laptop is running Win XP SP2 with SQL Server 2000 SP3, standard edition.
Can anyone shed any light on why the service will not start?
It seems to me that the service account does not have sufficient rights on the machine. Check errorlog directory, check database files directory etc. Check also the right to run as service for that account.
Also there are some issues with SP2 for Windows XP and SQL Server 2000 with SP3. Google for some solutions for that.
Hi everybody !
Try this :
- run Services from windows
- select SQLSERVERAGENT and go to properties page
- select LogOn Page from SQLSERVERAGENT properties
- tick This Account and select admin & set admin password
Thats it !