Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQLSERVERAGENT service is not running Expand / Collapse
Author
Message
Posted Wednesday, January 7, 2009 11:52 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, January 7, 2009 11:46 PM
Points: 1, Visits: 0
i have installed SQL server 2005
but i had a warning message while try to start the SQLSERVERAGENT service
"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 services"

And also i don't have the SQLAGENT.OUT file in the following path: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG

Please help me to start the SQLSERVERAGENT service
Post #632139
Posted Thursday, January 8, 2009 12:24 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, October 16, 2013 7:46 AM
Points: 533, Visits: 990
Check the application event log and post the error that you are getting there.


-Vikas Bindra


-Vikas Bindra
Post #632151
Posted Thursday, January 8, 2009 6:43 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, June 25, 2013 9:13 PM
Points: 190, Visits: 637
This is a error that usually appears when you are using a evaluation copy and if the 180 day period is expired.

This may not be in your case though.

Regards,
Post #632330
Posted Thursday, January 8, 2009 6:51 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Sunday, July 25, 2010 9:38 PM
Points: 107, Visits: 264
Check the Application and Security logs in Event Viewer.

Services often fail to start because they do not have the correct privileges. If this is the case, and you have Audit: Logon Event: Failure configured in Windows, then you will get an entry in the Security log. Check the Logon Type and compare it to the information here http://www.windowsecurity.com/articles/Logon-Types.html



--
Andrew Hatfield
Post #632338
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse