Post reply

Unable to start SQL Server Agent on SQL Server 2005

  • June 17, 2010 at 5:01 am

    #1181458

    Try to start SQL Server Agent from the command prompt using:

    **SQL 2005

    SQLAGENT90 -C -V>C:\SQLAGENT.OUT

    ***SQL 2008

    SQLAGENT.exe -C -V>C:\SQLAGENT.OUT

    If this is u r error:

    SQLAGENT.OUT:

    Unable to rename C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLAGENT.OUT to C:\ProgramFiles\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLAGENT.1 (reason: The system cannot find the path specified)

    2007-08-24 10:10:31 - ! [241] Startup error: Unable to initialize error reporting system (reason: The system cannot find the path specified)

    2007-08-24 10:10:31 - ? [098] SQLServerAgent terminated (normally)

    Then

    Resolution:

    Check the value of key ErrorLogFile in the following registry hive:

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\SQLServerAgent

    ErrorLogFile key had the below value:

    C:\ProgramFiles\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLAGENT.out

    However we did not had any such directory present on the machine. Also we did not had any SQLAgent log file.

    Changed the value in the ErrorLogFile key to reflect the correct location of the log folder which was on a different drive.

    After making the changes we were able to start the SQL Server Agent.

Viewing post 16 (of 15 total)

You must be logged in to reply to this topic. Login to reply