Home All Groups Group Topic Archive Search About

SQL Server 2005 Sgent will not start - Service Time out error



Author
3 May 2007 7:45 PM
pjslak
I have multiple instance of SQL2005 installed on my server all
services use the same User name and password.  The SQL Agent Services
for all of the instances will not start.  When I try to start the
services from Mgmt Studio I get
==================================
Unable to start service SQLSERVERAGENT on server DEVSQL2005.
===================================
Service Request Timeout (ObjectExplorer)
------------------------------
Program Location:
   at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.Service.CheckServiceActionReturnValueSuccess(UInt32
returnValue)
   at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.Service.Start()

When I try to start the service from Configuration Manager I get
---------------------------
SQL Server Configuration Manager
---------------------------
The request failed or the service did not respond in a timely fashion.
Consult the event log or other applicable error logs for details.
---------------------------
OK
---------------------------

My Server System Logs show
Date        5/1/2007 6:39:37 PM
Log        Windows NT (System)
Source        Service Control Manager
Category        (0)
Event        3221232481
Computer        DEVSQL2005
Message
Timeout (30000 milliseconds) waiting for the SQL Server Agent
(MSSQLSERVER) service to connect.

Date        5/1/2007 6:39:37 PM
Log        Windows NT (System)

Source        Service Control Manager
Category        (0)
Event        3221232472
Computer        DEVSQL2005

Message
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.

Any Ideas on where to start trouble shooting this?

Thanks

Author
4 May 2007 1:39 AM
Hari Prasad
Hello,

Can you change the service start account to Local System and try staring the
SQL Server Agent service. Use SQL Server configuration manager to chnage
the service startup account.

Thanks
Hari

<pjs***@gmail.com> wrote in message
Show quoteHide quote
news:1178221537.485735.233510@e65g2000hsc.googlegroups.com...
>
> I have multiple instance of SQL2005 installed on my server all
> services use the same User name and password.  The SQL Agent Services
> for all of the instances will not start.  When I try to start the
> services from Mgmt Studio I get
> ==================================
> Unable to start service SQLSERVERAGENT on server DEVSQL2005.
> ===================================
> Service Request Timeout (ObjectExplorer)
> ------------------------------
> Program Location:
>   at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.Service.CheckServiceActionReturnValueSuccess(UInt32
> returnValue)
>   at
> Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.Service.Start()
>
> When I try to start the service from Configuration Manager I get
> ---------------------------
> SQL Server Configuration Manager
> ---------------------------
> The request failed or the service did not respond in a timely fashion.
> Consult the event log or other applicable error logs for details.
> ---------------------------
> OK
> ---------------------------
>
> My Server System Logs show
> Date        5/1/2007 6:39:37 PM
> Log        Windows NT (System)
> Source        Service Control Manager
> Category        (0)
> Event        3221232481
> Computer        DEVSQL2005
> Message
> Timeout (30000 milliseconds) waiting for the SQL Server Agent
> (MSSQLSERVER) service to connect.
>
> Date        5/1/2007 6:39:37 PM
> Log        Windows NT (System)
>
> Source        Service Control Manager
> Category        (0)
> Event        3221232472
> Computer        DEVSQL2005
>
> Message
> 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.
>
> Any Ideas on where to start trouble shooting this?
>
> Thanks
>
Are all your drivers up to date? click for free checkup

Author
5 May 2007 3:15 AM
pjslak
Show quote Hide quote
On May 3, 6:39 pm, "Hari Prasad" <hari_prasa***@hotmail.com> wrote:
> Hello,
>
> Can you change the service start account to Local System and try staring the
> SQL Server Agent service. Use SQL Server configuration manager to chnage
> the service startup account.
>
> Thanks
> Hari
>
> <pjs***@gmail.com> wrote in message
>
> news:1178221537.485735.233510@e65g2000hsc.googlegroups.com...
>
>
>
> > I have multiple instance of SQL2005 installed on my server all
> > services use the same User name and password.  The SQL Agent Services
> > for all of the instances will not start.  When I try to start the
> > services from Mgmt Studio I get
> > ==================================
> > Unable to start service SQLSERVERAGENT on server DEVSQL2005.
> > ===================================
> > Service Request Timeout (ObjectExplorer)
> > ------------------------------
> > Program Location:
> >   at
> > Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.Service.CheckServiceActionReturnValueSuccess(UInt32
> > returnValue)
> >   at
> > Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.Service.Start()
>
> > When I try to start the service from Configuration Manager I get
> > ---------------------------
> > SQL Server Configuration Manager
> > ---------------------------
> > The request failed or the service did not respond in a timely fashion.
> > Consult the event log or other applicable error logs for details.
> > ---------------------------
> > OK
> > ---------------------------
>
> > My Server System Logs show
> > Date        5/1/2007 6:39:37 PM
> > Log        Windows NT (System)
> > Source        Service Control Manager
> > Category        (0)
> > Event        3221232481
> > Computer        DEVSQL2005
> > Message
> > Timeout (30000 milliseconds) waiting for the SQL Server Agent
> > (MSSQLSERVER) service to connect.
>
> > Date        5/1/2007 6:39:37 PM
> > Log        Windows NT (System)
>
> > Source        Service Control Manager
> > Category        (0)
> > Event        3221232472
> > Computer        DEVSQL2005
>
> > Message
> > 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.
>
> > Any Ideas on where to start trouble shooting this?
>
> > Thanks

This worked.  but do you know why?
Author
9 May 2007 5:10 AM
Sue Hoegemeier
A permissions issue or something wrong with the account.
Make sure to change the service accounts using Configuration
Manager. Check the service account - make sure it's not
locked out. Try to log on to one of the servers using the
account to make sure it's working okay.
Make sure the password is sent to never expire (and then
implement you own schedule of changing the password)
Make sure the service account is a member of the sysadmins
server role. 

-Sue

On 4 May 2007 20:15:00 -0700, pjs***@gmail.com wrote:

Show quoteHide quote
>This worked.  but do you know why?

Bookmark and Share