Sqlserveragent service started and then stopped
-
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.
-
Also, if you are using a domain\username account for the SQL Agent service you might want to check in SQL Server that it is a valid account and has sysadmin role. This is a must if you have removed Builtin\Administrators.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
-
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 !
Regards
Majid Ranjkesh
-
For security reasons you should not use services from control panel, and you should not use administrator accounts.
SQL Server runs just fine with normal user accounts. To set them use Enterprise Manager for SQL Server 2000 or SQL Server Configuration for SQL Server 2005. The proper rights are then automatically applied to all directories, registry settings and users. Place the service accounts and computers in seperate OU containers wich blocks certain policies.
-
Thank....
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply