Tuesday, July 16, 2013

The process terminated unexpectedly SQL Server Agent

SQL Server Agent could not started because of the below error
The process terminated unexpectedly

First we need to identify what the issue causing agent not to start, to do so follow the below process
Identify SQLAgent executable file location and run it from the command prompt as below
c:\mssql> sqlagent -c -v >sqlagent.out
opent the sqlagent.out file to identify the issue, I have the below issue in .out file

! [000] Unable to connect to server '(local)'; SQLServerAgent cannot start
! [298] SQLServer Error: 18456, Login failed for user 'domain\username'. [SQLSTATE 28000]
! [382] Logon to server '(local)' failed (DisableAgentXPs)
? [098] SQLServerAgent terminated (normally)
Then I realized that SQL Agent is not able to contact the installed instance,  I tried several ways to fix it finally I have added the SQL Service account to SQL Server as a windows login and provided sysadmin rights to it, later I can able to start the agent.


No comments: