SQLAgent Will Not Start

SQLAgent Will Not Start - Error 1053

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ulysses - 22 Jul 2008 20:56 GMT

I am running SQL Server 2005 SP2. I am unable to get the SQL Server Agent
(MSSQLSERVER) service on Local Computer to start under any account other
than Local System. The error is:
Error 1053: The service did not respond to the start or control request in a
timely fashion.

Both the SQL Server Service and the SQL Server Reporting Services Service
run fine under the user accounts that I have been trying to run the SQL
Agent under. I am able to start and restart them with no problem.

I have tried Local Administrator Accounts and Domain Administrator Accounts
with the same results (Error 1053). Any help would be appreciated.

Reply to this Message

Ekrem Önsoy - 22 Jul 2008 21:17 GMT

You should check out the Windows Event Logs. They'll tell you the reason of
the error more descriptive.

Signature

Ekrem Önsoy

>I am running SQL Server 2005 SP2. I am unable to get the SQL Server Agent
>(MSSQLSERVER) service on Local Computer to start under any account other
[quoted text clipped - 9 lines]
> Accounts with the same results (Error 1053). Any help would be
> appreciated.

Reply to this Message

Ulysses - 22 Jul 2008 21:37 GMT

I do not find the Event Log information very informative. However, here it
is. I hopes this helps you to help me get this resolved.

Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7000
Date: 7/22/2008
Time: 4:32:24 PM
User: N/A
Computer: WSV3AS07
Description:
The SQL Server Agent (MSSQLSERVER) service failed to start due to the
following error:
The service did not respond to the start or control request in a timely
fashion.

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.

Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7009
Date: 7/22/2008
Time: 4:32:24 PM
User: N/A
Computer: WSV3AS07
Description:
Timeout (30000 milliseconds) waiting for the SQL Server Agent (MSSQLSERVER)
service to connect.

For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.

Reply to this Message

Charles Wang [MSFT] - 23 Jul 2008 11:24 GMT

Hi Ulysses,
For further research, could you please mail me (changliw_at_microsoft_dot_com) all the SQL Error logs in the folder%
ProgramFiles%\Microsoft SQL Server\MSSQL(.n)\MSSQL\LOG?

Also I recommend that you run Process Monitor to monitor your SQL Server Agent process "SQLAGENT90.EXE" and send me the
trace logs. You can download Process Monitor from this link:
Process Monitor v1.35
http://technet.microsoft.com/en-us/sysinternals/bb896645.aspx?PHPSESSID=d926

Please feel free to let me know if you have any other questions or concerns.

Best regards,
Charles Wang
Microsoft Online Community Support
===========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg@microsoft.com.
===========================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notifications.

Note: The MSDN Managed Newsgroup support offering is for
non-urgent issues where an initial response from the community
or a Microsoft Support Engineer within 1 business day is acceptable.
Please note that each follow up response may take approximately
2 business days as the support professional working with you may
need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
============================================================

Signature

This posting is provided "AS IS" with no warranties, and confers no rights.

=========================================================

Reply to this Message

Ekrem Önsoy - 25 Jul 2008 08:06 GMT

Also, as Uri said you should change your SQL Server services' service
accounts using SQL Server Configuration Manager as this tool automatically
add your service account to the built-in SQL Server groups so that this
account would have enough rights to run the relevant service.

So, do you perform these SQL Server service changes through Configuration
Manager or Services MMC?

Signature

Ekrem Önsoy

>I do not find the Event Log information very informative. However, here it
>is. I hopes this helps you to help me get this resolved.
[quoted text clipped - 30 lines]
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.

Reply to this Message

Ekrem Önsoy - 22 Jul 2008 21:17 GMT

You should check out the Windows Event Logs. They'll tell you the reason of
the error more descriptive.

Signature

Ekrem Önsoy

Reply to this Message

Uri Dimant - 23 Jul 2008 06:34 GMT

Hi
Tryg using configuration mgr to reset the startup account. this should
ensure proper permissions are given to the acct/new domain/ local group.
See also
http://support.microsoft.com/kb/886695

Reply to this Message