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.

I was bit puzzled and looked into the Windows Application Error Log. It showed me following 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)

About these ads

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

  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

    • I’m using “Local System Account” for MSSQLSERVER to have full rights when lunching scripts via EXEC xp_cmdShell.

  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

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

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

  5. sir how to change the password in installed server .but i am using same password only to connect the sql sever 2005 express

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

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

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

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

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

  11. 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?

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

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

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

  15. when i open sqlservices in sqlserver configuration manager not able to see start option on services and they are not running

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

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

  18. 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!

  19. Dear Experts
    I have facing the major problem for the SQL password is reset automatically. Do you have the any solutions
    Please reply…….

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