SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Sqlserveragent service started and then stopped


Sqlserveragent service started and then stopped

Author
Message
David Clark-152013
David Clark-152013
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 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?


Gé Brander
Gé Brander
Old Hand
Old Hand (359 reputation)Old Hand (359 reputation)Old Hand (359 reputation)Old Hand (359 reputation)Old Hand (359 reputation)Old Hand (359 reputation)Old Hand (359 reputation)Old Hand (359 reputation)

Group: General Forum Members
Points: 359 Visits: 56

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.





Rudyx - the Doctor
Rudyx - the Doctor
SSCarpal Tunnel
SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)

Group: General Forum Members
Points: 4761 Visits: 2503
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."
mehrdadTehran
mehrdadTehran
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 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


Gé Brander
Gé Brander
Old Hand
Old Hand (359 reputation)Old Hand (359 reputation)Old Hand (359 reputation)Old Hand (359 reputation)Old Hand (359 reputation)Old Hand (359 reputation)Old Hand (359 reputation)Old Hand (359 reputation)

Group: General Forum Members
Points: 359 Visits: 56
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.



ronald_mdj
ronald_mdj
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 Visits: 0
Thank....
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search