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)
 SQLSERVERAGENT won't start !!!!!!!!!!!

Author  Topic 

winsys
Starting Member

3 Posts

Posted - 2007-05-23 : 20:33:52
SQLSERVERAGENT Service won't start.
MSSQLSERVER Service starts fine.
Both Services using 'Local System' account.
Server is Windows Server 2003 SP1
SQL 2000 Server SP3a
Any Ideas?
Thanks

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2007-05-23 : 22:13:26
look for errors in the nt event log and/or SQLAGENT.OUT

a common reason for this is that the agent service is not able to connect to the sql instance because of perms issues.


www.elsasoft.org
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-05-23 : 22:44:17
Did you remove builtin\administrators from sysadmin? If so, did you add 'nt authority\system' in sysadmin?
Go to Top of Page
   

- Advertisement -