Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Location
    Poland
    Posts
    35

    Exclamation Unanswered: SQL Server Agent 2005 could not start

    Hi,

    If i trying to start SQL Server Agent error message i display:

    "The request failed or the service did not respond in timely fashion. Consult the event log or other applicable error logs for detail"

    I am using the same windows logon for MSSQLServer, Browser which is running. I've tried to run as the Local System - still the same error.

    I've restarted few times server (Windows 2003) - no success

    ...also i've tried to start the service from command line:
    sqlagent90.exe -i mssqlserver

    " startservicectrldispatcher failed (error 6)"

    Could you please help me

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    What is in the SQL Agent errorlog?

  3. #3
    Join Date
    Jan 2004
    Location
    Poland
    Posts
    35
    SQLAGENT.OUT
    -----------------

    2009-10-09 18:43:32 - ! [000] Unable to connect to server '(local)'; SQLServerAgent cannot start
    2009-10-09 18:43:32 - ! [298] SQLServer Error: 18456, Login failed for user 'DP\s-SQLOmega'. [SQLSTATE 28000]
    2009-10-09 18:43:32 - ! [382] Logon to server '(local)' failed (DisableAgentXPs)
    2009-10-09 18:43:32 - ? [098] SQLServerAgent terminated (normally)


    ERRORLOG
    ------------
    2009-10-09 16:56:08.96 Logon Error: 18456, Severity: 14, State: 11.
    2009-10-09 16:56:08.96 Logon Login failed for user 'DP\s-SQLOmega'. [CLIENT: <local machine>]
    2009-10-09 16:56:09.23 spid9s Starting up database 'tempdb'.
    2009-10-09 16:56:09.39 Logon Error: 18456, Severity: 14, State: 16.
    2009-10-09 16:56:09.39 Logon Login failed for user 'bc'. [CLIENT: 10.144.32.34]
    2009-10-09 16:56:09.70 spid12s The Service Broker protocol transport is disabled or not configured.
    2009-10-09 16:56:09.70 spid12s The Database Mirroring protocol transport is disabled or not configured.
    2009-10-09 16:56:09.82 spid12s Service Broker manager has started.
    2009-10-09 16:56:11.07 spid14s Recovery is writing a checkpoint in database 'OmegaPRD' (6). This is an informational message only. No user action is required.
    2009-10-09 16:56:11.23 spid5s Recovery of any in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC) has completed. This is an informational message only. No user action is required.
    2009-10-09 16:56:11.23 spid5s Recovery is complete. This is an informational message only. No user action is required.
    2009-10-09 16:56:11.32 spid5s Launched startup procedure 'sp_MSrepl_startup'.
    2009-10-09 16:56:11.32 spid5s Launched startup procedure 'sp_ApexSqlConnectionMonitor2008_Start'.
    2009-10-09 16:56:11.33 spid54s Using 'ApexSqlServerXprocs2008.DLL' version '2008.01.00' to execute extended stored procedure 'xp_ApexSqlConnectionMonitor2008'. This is an informational message only; no user action is required.
    2009-10-09 16:56:11.33 spid54s Starting ApexSQL Connection Monitor on server DPD\MSSQLSERVER
    2009-10-09 16:56:11.47 Logon Error: 18456, Severity: 14, State: 11.
    2009-10-09 16:56:11.47 Logon Login failed for user 'DP\s-SQLOmega'. [CLIENT:


    -----------------------------------------

    SQL Server is running wih DP\s-SQLOmega
    Browser is running with DP\s-SQLOmega

    Domain account DP\s-SQLOmega is member local Administrators group
    Pasword for DP\s-SQLOmega newer expires and is not locked out.

    Nobody don't know sa password ( unfortunatelly is locked )

  4. #4
    Join Date
    Jan 2004
    Location
    Poland
    Posts
    35
    sorry, mistake

    Pasword for DP\s-SQLOmega newer expires and is not locked

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •