Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQL Server Agent doesn't start

Author  Topic 

CanadaDBA

583 Posts

Posted - 2004-08-26 : 15:22:12
I have a remote server. Using VNC, I run the EM and on SQL Server Agent's R-Click menu, I choose start for several time and it doesn't start. Why?

Canada DBA

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-08-26 : 15:36:38
On the server, go to Control Panel, then Admin Tools, then Services. Check the status of the SQLSERVERAGENT service. If it isn't started, try starting it. If you get an error, check the Application Log in Event Viewer for the reason. Post it here. If it stays in a starting state and changes to started, then you might need to reboot the box.

Tara
Go to Top of Page

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2004-08-27 : 06:27:29
before rebooting you may want to:
check the account that runs the sql services if it's a domain user account and is a member of local admin group
Go to Top of Page
   

- Advertisement -