Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I'm unable to start the SQL Server agent in services. I'm getting the following error while starting.

SQL Server Agent service in local computer started and then stopped. Some services automatically stop if they have no work to do, for example, the performance logs and alert service.

share|improve this question

migrated from stackoverflow.com Feb 9 '10 at 15:57

This question came from our site for professional and enthusiast programmers.

3 Answers 3

up vote 0 down vote accepted

SQL Server has its own log - check that as well as the Windows event log. Also, see if the account that SQL Server Agent runs under has the correct password etc. Will the Agent run under the Local System account (temporarily)?

share|improve this answer

That is generic message for any problem with launch of services. You could try to find error's description in logs (i am not sure - windows error log or specific log file). Try repair reinstalling SQL Server or Service Packs.

share|improve this answer
    
I changed the account from Local System to NT Authority\Network Service. Now it is working. But, don't know why it is not running with local service... –  Vennila Feb 9 '10 at 7:41

Check out your SQL agent log which should be here, replacing the bracketed pieces with whatever is appropriate... although this is just the default install directory, so it may be slightly different if you installed somewhere else:

C:\Program Files\Microsoft SQL Server\MSSQL.\MSSQL\Log\SQLAGENT.OUT

Try changing the service back to Local System and start it then post the most recent ouput in that file, might be able to help more with that.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.