Post reply

SQLSERVERAGENT Could not start automatically

  • December 28, 2011 at 8:03 am

    #250478

    SQLSERVERAGENT Could not start automatically

    please reply.

  • December 28, 2011 at 8:05 am

    #1426098

    What’s the error you are getting?

  • December 28, 2011 at 8:48 am

    #1426127

    Nothing, error showing in the log file and one more thing i should tell you both sql server and sqlerver agent are configure with same local account in sql server 2000.

  • December 28, 2011 at 8:54 am

    #1426131

    Please check Windows Event Log. It logs service failure messages with some information.

  • December 29, 2011 at 2:53 am

    #1426362

    @ashish,

    go to services.msc and check have you selected the "manual" option ?

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • December 29, 2011 at 3:12 am

    #1426368

    SQLAGENT.OUT is the log file for SQL Server Agent, and this is where you should start looking. What does it say in that file? If the file doesn't exist then it's likely that either an invalid location for it is specified, or the SQL Server Agent service account doesn't have permission to write to it.

    John

  • December 29, 2011 at 4:59 am

    #1426383

    HI,

    I had the same problem and solved it by increasing the Timeout Init Service. To do this we must add a new value to the registry key "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control". The new value is called ServicesPipeTimeout and is of type DWORD, you enter the number of timeout milliseconds (default is 30000ms), try for instance 60000ms

Viewing 7 posts - 1 through 6 (of 6 total)

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