|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SQL Server 2005 Sgent will not start - Service Time out error
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 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 >
Show quote
Hide quote
On May 3, 6:39 pm, "Hari Prasad" <hari_prasa***@hotmail.com> wrote: This worked. but do you know why?> 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 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?
Other interesting topics
SQL Server 2005 Linked Server IDENTITY_INSERT
how can I tell if a query is running SQL Server high utilization Difference between Index & Statistics CPU usage and troubleshoot (sp_who2, profiling) The data types text and nvarchar are incompatible in the equal to operator. How to read SQL file ? Outer Join Problem - hardest query ever? Could not allocate space for object 'xxx' in database 'abc' becaus Bandwidth Utilization... |
|||||||||||||||||||||||