Sql Server Request Failed Timely Fashion

In this post i will starting time generate the error

"The request failed or the service did not respond in a timely manner.Consult the event log or other application error logs for details."

and subsequently i will troubleshoot this error in SQL Server.

Important to note:  This is just a demonstration. Please never try the same demo in your work environment  because in this mail i will be going to start and terminate SQL Server Services and fifty-fifty rename my master.mdf file to generate the error.Considering if sql server gets stopped and primary file somehow get corrupted then your visitor's application may stop and information technology volition not be proficient for you and the company.You can try it on your personal computer for learning.

First i will rename my principal database file which is principal.mdf to master_renamed.mdf and later on when i will endeavor to start the SQL Server Services using SQL Server Configuration Director i will go the mistake:
"The asking failed or the service did not answer in a timely style.Consult the event log or other awarding mistake logs for details."
and later on that i will fix this error.

I will go to Starting time, All Programs, Microsoft SQL Server 2012 ,Configuration tools, SQL Server Configuration Manager,select SQL Server Services and Right Click on SQL Server(MSSQLSERVER) and cease the service as shown in the image below.

Now i go to the location where main.mdf is present and rename it to master_renamed.mdf as shown below.

Now i again endeavour to outset the services in SQL Server Configuration Manager
equally shown below

Just the sql server service is not starting up and i got the fault message as shown below
"The request failed or the service did not reply in a timely manner.Consult the upshot log or other application error logs for details."

There are 2 places where you can view the reason of the error.
1)  The application log of Window OS
ii)  ErrorLog of SQL Server

First i volition testify you how you can get to awarding log and view the details of the error.
You need to right click on the Calculator and select One thousandanage pick equally shown below.

Expand Server Manager Diagnostics,Upshot Viewer,Window Logs,Application and view the mistake where the source is MSSQLSERVER as shown in the paradigm beneath. "The system cannot find the file specified". It means main.mdf isn't available and without principal DB SQL Server volition non be started.

Some other option is to view the Error Log which is created by SQL Server. To
know the path of the ErrorLog file , right click on SQL Server(MSSQLSERVER) in SQL Server Configuration Managing director and go to the properties as shown below.

Go to startup parameters and view the path which starts with -e. This is actually the path of ErrorLog file as shown beneath.

Now go to te path which is present in the Startup Parameters preceding with -due east and open ErrorLog in notepad as shown below.

Information technology is besides showing the aforementioned error bulletin which we accept seen in the application log as shown below.

At present get to the location which is specified by Error Log or Application Log and rename master_renamed.mdf back to master.mdf equally shown below.

Now go to SQL Server Configuration Director and start the SQL Server(MSSQLSERVER) and this time information technology will start upward.

Share this post