Erro ao Inicializar o SQLAgent
Enviado: 22 Mai 2014, 17:03Mensagem 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
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