Mensagem de erro:
the sql server agent service on local computer started and then stopped
Solução:
I got this error while i am trying to start the SQLSERVERAGENT(SQLSERVER 2000)from services(services.msc).If i right Click and trying to start the service i am getting this error.
Solution for this is: Go to Properties of SQLServerAgent->Connections->Check SQL ServerAuthentication->Choose Logins from dropdownlist and he should be the member of sysadmin role.Click Ok.
Then SQL Server Agent will start