Post reply

Can't start SQL Agent

  • September 21, 2009 at 9:51 am

    #210022

    Was working fine, now service is stopped if I go to start the service I get

    "the request failed to start in a timley fashion"

    the error log shows:

    SQLServerAgent could not be started (reason: Unable to connect to server '(local)'; SQLServerAgent cannot start).

    the sql.out file shows:

    2009-09-21 11:48:30 - ! [298] SQLServer Error: 18456, Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. [SQLSTATE 28000]

    2009-09-21 11:48:30 - ! [000] Unable to connect to server '(local)'; SQLServerAgent cannot start

    2009-09-21 11:48:30 - ! [298] SQLServer Error: 18456, Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. [SQLSTATE 28000]

    2009-09-21 11:48:30 - ! [382] Logon to server '(local)' failed (DisableAgentXPs)

    2009-09-21 11:48:31 - ? [098] SQLServerAgent terminated (normally)

    Ive tried all kinds of users..none of them seem to work...

  • September 21, 2009 at 10:03 am

    #1056352

    I got it...thanks guys

  • September 22, 2009 at 12:44 am

    #1056573

    Okay, what was that problem?

    -Forum Etiquette: How to post Performance Problems[/url]

    -Forum Etiquette: How to post data/code to get the best help [/url]

Viewing 3 posts - 1 through 2 (of 2 total)

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