Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2003
    Posts
    2

    Unanswered: "SQLServerAgent service hung on starting"

    Since I installed sp4 for sql7 on 3 NT-machines last week, I get this message from Service Control Manager on every reboot of those PC's. After checking in the NT EventViewer, the SQLServerAgent service is really started but about 15-20 seconds after the error message.

    EventID 7022
    SERVICE CONTROL MANAGER
    "SQLServerAgent service hung on starting"

    Any idea how to solve this or what causes this?

  2. #2
    Join Date
    Sep 2003
    Location
    Dallas, Texas
    Posts
    311

    Re: "SQLServerAgent service hung on starting"

    Take a look at your SQL Error log. SQL Server Agent will not be able to start unless the error log shows 'Recovery Complete'.

  3. #3
    Join Date
    Feb 2002
    Posts
    2,232
    Check your odbc administrator -> tracing -> check to see if it is enabled (if it is, stop the tracing).

  4. #4
    Join Date
    Dec 2003
    Posts
    2
    Thanks for your replies. Problem solved, the error message was caused because I also disabled the Messenger service (for security reasons). Now I enabled it again & the SQGAgent Service starts on reboot without the error warning. I still wonder why because I don't like leaving the Messenger service running.

Posting Permissions

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