I recently uninstalled and install SQL Server 2008 R2 on my machine. Then, I found out that SQL Agent fails to start. It starts and stops immediately. There were no errors in Event logs or SQL logs. I am unable to open the SQLAgent.1 or SQLAgent.OUT log files. Whenever I tried to open these files, windows prompts with “Unable to Open” message.

I check the permissions. System, Administrators, SQLServerMSSQLUser$……… as well as SQLServerSQLAgentUser$….. all had the appropriate Read and Write permissions.

Then, I found a Microsoft blog explaining old SQLAgent.OUT log file may not be accessible by the SQLAgentUser and therefore, blocking the SQLAgent from starting.

http://blogs.msdn.com/b/sqlagent/archive/2010/12/08/troubleshooting-sql-agent-can-t-start-without-sqlagent-out-telling-the-reason.aspx

To solve this:

  1. Make sure SQLServerSQLAgentUser$…………. has ReadWrite access to the Log folder. The format of username follows the pattern “SQLServerSQLAgentUser$MachineName$InstanceName”.
  2. Delete or rename all old SQLAgent.x log files. The log files are usually under Program Files\Microsoft SQL Server\MSSQL\LOG. However, the location can be changed.
  3. Restart the SQL Agent.

That worked for me. SQL Agent started successfully. A new SQLAgent.OUT log file was created.

Happy Troubleshooting!!!

SQL Server Agent Starts and Stops immediately.
Tagged on:     

2 thoughts on “SQL Server Agent Starts and Stops immediately.

  • July 12, 2013 at 8:51 pm
    Permalink

    Hi, U say the steps good, but how I can apply these
    1)how can I be sure that SQLServerSQLAgentUser has readwrite acces to the log folder? and what it is SQLServerSQLAgentUser ?
    2)where’s these SQLAgent.x log files

    Reply
    • December 25, 2013 at 8:34 pm
      Permalink

      I have the updated the microsoft blog that referenced as well as updated the blog answering your questions.

      Reply

Leave a Reply

Your email address will not be published. Required fields are marked *