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 started and then stopped Expand / Collapse
Author
Message
Posted Monday, April 11, 2005 4:17 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, August 27, 2007 11:22 AM
Points: 2, Visits: 1

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?

 

Post #173855
Posted Monday, April 11, 2005 11:34 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, June 13, 2011 11:45 AM
Points: 221, Visits: 55

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.




Post #173916
Posted Tuesday, April 12, 2005 9:53 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 3:44 PM
Points: 3,221, Visits: 2,375
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.



Regards
Rudy Komacsar
Senior Database Administrator

"Ave Caesar! - Morituri te salutamus."
Post #174093
Posted Sunday, August 26, 2007 4:02 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, September 1, 2007 1:53 AM
Points: 1, Visits: 1

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

Rnj_M@yahoo.com

 

 

Post #393887
Posted Monday, August 27, 2007 11:31 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, June 13, 2011 11:45 AM
Points: 221, Visits: 55
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.



Post #394201
Posted Monday, September 20, 2010 11:58 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, September 20, 2010 11:57 PM
Points: 1, Visits: 0
Thank....
Post #989960
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse