Kevin Kilpatrick wrote:
> For an unknown reason, every time I try to start the SQLSERVERAGENT,
> it immediately stops. It will not stay running. I've set it to
> automatic. I've tried to start it manually. I suspect the
> unstartable agent is also the cause of a multitude of connection
> issues - mainly, I can't connect to the server. I've searched MS
> MSDN and found nothing that helps. Does anyone have any suggestions.
>

"Andrea Montanari" <andrea.sqlDMO@virgilio.it> wrote in message
news:4enl21F1fouc7U1@individual.net...
> hi Kevin,
> Kevin Kilpatrick wrote:
>> For an unknown reason, every time I try to start the SQLSERVERAGENT,
>> it immediately stops. It will not stay running. I've set it to
>> automatic. I've tried to start it manually. I suspect the
>> unstartable agent is also the cause of a multitude of connection
>> issues - mainly, I can't connect to the server. I've searched MS
>> MSDN and found nothing that helps. Does anyone have any suggestions.
>>
> try having a look at the SQLAGENT.OUT log file in the \Program
> Files\Microsoft SQL Server\MSSQL\Log\ folder (MSSQL$InstanceName for
> named instances) and in the event viewer for the problem causing the Agent
> not to start..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz http://italy.mvps.org
> DbaMgr2k ver 0.19.0 - DbaMgr ver 0.63.0 and further SQL Tools
> --------- remove DMO to reply
>