Two days ago, I was participating TechEd India 2011 and I had a 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 the office and turned on the machine, it did not start SQL Server. I was a bit confused and very quickly checked SQL Server Services. I noticed that services were OFF. I tried to turn on the services, but it keeps on giving me following error about request failed.
Error:
The request failed or the service did not respond in a 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 wends away.
Let me know what you think about this error, are you still facing this error today? I believe the latest version of the SQL Server this error has been fixed.
Reference: Pinal Dave (https://blog.sqlauthority.com)
80 Comments. Leave new
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.
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.
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.
sir how to change the password in installed server .but i am using same password only to connect the sql sever 2005 express
Great!!! Directly to the point! :D
the particular website is log in server..how to open the log website in a system
I don’t know how to thank you Pinal, You are my super SQL man. thank you very much.
This is really quick help for me…Thanks.
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
thanks it works :)
how u solved access denied issue?
how it works plz help me……
How was this resolved? I need to know.
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.
This is the perfect solution to the problem. It works like magic. I have issues with this from many days. Now it resolved.
Thanks,
Hi Deepak it has really helped .
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
You saved my day! Thanks for the info and the ever useful site.
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
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
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?
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.
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.
thanks a lot for sharing your solution. it helped me.
I am getting this error during installation, what should I do?