Home Forums SQL Server 2008 SQL Server Newbies SQL Server Agent won't start - The system cannot find the file specified RE: SQL Server Agent won't start - The system cannot find the file specified

  • acraddock (7/9/2013)


    Hi,

    For a while now we have been running SQL for our ERP system.

    Recently i have noticed that a rebuild indexes task has not been running on the SQL database.

    On closer inspection, i noticed that the SQL server agent is not running - when i try and start the service it tells me 'windows could not start the service - error 2: the system cannot find the file specified.

    I have taken a look at some posts already which refer the checking the location of the sqlagent.out log file path in the registry.

    This would all appear ok - but when i try to start the service this file is not updating....

    I have also tried renaming the file to see if a new file is create but nothing happens....

    Any advice or pointers that could be given would be greatly appreciated.

    Cheers

    Alan

    Any changes in the SQL Agent account? Make sure the account has all the necessary permissions. Also read/write permission on the folder where the log files are stored.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP