SQL SERVER – Fix : Error : The request failed or the service did not respond in timely fashion. Consult the event log or other applicable error logs for details

Two days ago, I was participating TechEd India 2011 and I had great time presenting on various subjects. My computer fortunately behaved very well and I consider myself lucky for it. However, very next day today, when I went to office and turned on the machine, it did not start SQL Server. I was bit confused and very quickly checked SQL Server Services. I noticed that services were OFF. I tried to turn on the services but it keep on giving me following error.

Error:

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

 SQL SERVER   Fix : Error : The request failed or the service did not respond in timely fashion. Consult the event log or other applicable error logs for details

I was bit puzzled and looked into the Windows Application Error Log. It showed me following details:

StartError1 SQL SERVER   Fix : Error : The request failed or the service did not respond in timely fashion. Consult the event log or other applicable error logs for details

When I looked at above error I right away realized what had happened.

Fix/Workaround/Resolution:

My organization has policy to change password at frequent interval. I had changed the password the day before and because of the same all the services were down. I quickly went to Property of the service and change the password to my updated password.

Once done when I attempted to start the service, it worked well and error wend away.

Reference: Pinal Dave (http://blog.SQLAuthority.com)

60 thoughts on “SQL SERVER – Fix : Error : The request failed or the service did not respond in timely fashion. Consult the event log or other applicable error logs for details

  1. Hi Pinal,

    Thanks for sharing, but out of curiosity I want to ask that why would you run your SQL Server with your own personal login. Why not LocalSystem, LocalService or NetworkService accounts which have more privilages and minimal chances of getting expired.

    Cheers.

    Like

  2. You are right Mohammad! My point exactly.

    We faced similar situation when our company implemented the password expiry policy. Ever since we changed the service to start in “Local System Account” we never faced this issue.

    My question is:

    What are the pros/cons of having “Local System Account” setting for service start up?

    -RealRM

    Like

  3. As a general rule of thumb (we, at our organization) refrain from using any personal accounts for any service. We also refrain from using any SYSTEM or Local/Network/SERVICE accounts as they typically have more than necessary permissions.

    We do create AD-Domain based service accounts with complex password requirements and have a group policy that exempts them from password change requirements.

    -A

    Like

    • Aashish, that is the same here. It also makes inter-server processes easier to manage if all the sql servers are running under managed accounts, such as mirroring, log shipping, and linked servers.

      Like

  4. Pingback: SQL SERVER – FIX – ERROR – Service Logon Failure (ObjectExplorer) Journey to SQLAuthority

  5. Hi , I am facing the same issue because of changing the password but when i try to set the new password Iam getting “Access is denied[ 0x8007005] please help

    Like

  6. 0 down vote

    It was very tedious when I get same problem.When I got this problem then I uninstall my SQL Server 2008 but after installing again SQL server 2008 I was getting same problem. I was so tens and I had not get any help from any site. To over come this problem. Simply You Need to go on SQL Server Configuration Manager and then click On Protocols on left panel. If you running Network service just disable ‘VIA’ Protocol. And after that try to start your SQL service it will run successful.

    Like

  7. Hi Deepak,
    Yourn e solution is correct,I get same problem but when disable ‘VIA’ PROTOCOL and start SQL Service it’s working well.
    Thank You very Much Deepak

    Like

  8. I am also facing the same problem but the thing is I have not changed any error. I just changed the tcp port no in TCP/IP protocal service and restarted the sql services but it stopped and it is not starting when I click on start it is giving error. The request failed or service did not respond in timely fashion. I changed all the changes I have done for protocol and started again but still it is not working

    Like

  9. I am also facing the same problem but the thing is I have not changed any password. I just changed the tcp port no in TCP/IP protocal service and restarted the sql services but it stopped and it is not starting when I click on start it is giving error. The request failed or service did not respond in timely fashion. I changed all the changes I have done for protocol and started again but still it is not working

    Like

  10. i have done all these things but still server not running, In TCP/IP protocols and in IP address tab i have only IP1 and IP All but in my laptop there r many options Is this reason?

    Like

  11. I am facing same problem with error no. 3414. I have checked event log and its showing..

    The log scan number (25:224:1) passed to log scan in database ‘model’ is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup.

    Please help.

    Like

  12. I am facing same problem with error no 3414. Event log is showing..

    The log scan number (25:224:1) passed to log scan in database ‘model’ is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf). If this error occurred during replication, re-create the publication. Otherwise, restore from backup if the problem results in a failure during startup.

    Please help.

    Like

  13. Thank you very much!! In addition I’d like to say where you can change it:
    Sql server configuration manager -> sql server Services -> SQL server (“you instance”) -> right click -> properties -> change you password and click run.

    Like

  14. SQL Server 2008 R2 failed to start after a power interruption on my computer. I’ve looked at the remedies suggested including disabling VIA, changing the “Network Service” account password and trying to start it from Services.msc. Unfortunately, all are not working for me. What is the cause of the problem in the first place? How can I fix it without re-installing SQL Server? Thanks in advance

    Like

  15. I’m seeing the same issues.
    I fixed: goto: Configuration Tools >> SQL Server Configuration Manager >> SQL Server Network Configuration >> Name Pipes >> Pipes name –> \\.\pipe\MSSQL\sql\query

    Like

  16. first of all i would like to thank you for a great site.
    im having same problem as you had. im running windows 7 home premium with no user password. in sql server network configuration VIA is disable. still i cant get the server agent running. but if i stop SQL server (MSQLSERVER) then SQL Server agent (MYSQLSERVER) starts without showing any error.
    HELP!

    Like

  17. I followed a step by step on an other post, turned out it worked perfectly. All I had to do is to disable VIA protocol.

    My question is, what is that protocol for? Won’t it disturb my other applications depending on that particular Data base such as sharepoint? I’m worried about that.

    Like

  18. Hi Pinal,
    I am having the same issue on SQL Server 2012. I need to start SQL Server Agent . I have tried this for all the way above mentioned scenarios .

    Error is:
    “The request failed or the service did not respond in timely fashion. Consult the event log or other applicable error logs for details”
    I have . Please help me on this.

    Like

  19. Una pregunta:

    .- Cuales son los requerimientos para que se active: SQL Server Agent
    .- Versión en especifico de SQL Server, o se puede en SQL Server 2008 r2 sp2 express?

    Muchas gracias, ya que no logro que se active SQL Server Agent

    Me interesa activar este componente, ya que me han comentado que se pueden programar respaldos de las Bases de Datos, con este componente.

    Like

  20. Una Pregunta:

    .- Cuales son los requerimientos para que se active: SQL Server Agent
    .- Versión en especifico de SQL Server, o se puede en SQL Server 2008 r2 sp2 express?

    ya que no logro que se active SQL Server Agent

    Me interesa activar este componente, ya que me han comentado que se pueden programar respaldos de las Bases de Datos, con este componente.

    De antemano muchas gracias.

    Like

  21. I am having the same issue but its different with me.
    Earlier today i moved my system databases from C drive to anither drive and I tried to restart my services it throws the same error.
    I specified the correct path in input oarameters too still it doesnt allow me to restart.

    Like

  22. what privileges must have a domain account to start the SQL Server Agent, because i use an account that is part of domain users but cant start de sql server agent, only when I add the domain account to local admins group can start de service, which are the minimal privileges to do this?

    Like

  23. the request failed or the service did not respond in a timely fashion sql 2012
    issue when I am starting Sql server agent . and in My protocol there is no VIA protocol.
    what is solution for this

    Like

    • Go to Start > Run > and type regedit
      Navigate to: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control
      With the control folder selected, right click in the pane on the right and select new DWORD Value
      Name the new DWORD: ServicesPipeTimeout
      Right-click ServicesPipeTimeout, and then click Modify
      Click Decimal, type ‘180000’, and then click OK
      Restart the computer

      I tried Above Step but it will not work in my case…

      Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s