SQL Server

The request failed or the service did not respond in a timely fashion.Consult the event log or other application error logs for details–How to troubleshoot it

In this post i will first generate the error

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

and later 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 post i will be going to start and stop SQL Server Services and even rename my master.mdf file to generate the error.Because if sql server gets stopped and master file somehow get corrupted then your company’s application may stop and it will not be good for you and the company.You can try it on your personal computer for learning.

First i will rename my master database file which is master.mdf to master_renamed.mdf and later on when i will try to start the SQL Server Services using SQL Server Configuration Manager i will get the error:
“The request failed or the service did not respond in a timely fashion.Consult the event log or other application error logs for details.”
and after that i will fix this error.

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

 

SQL Server : The request failed or the service did not respond in a timely fashion.Consult the event log or other application error logs for details

 

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

 

SQL Server : The request failed or the service did not respond in a timely fashion.Consult the event log or other application error logs for details

 

Now i again try to start the services in SQL Server Configuration Manager
as shown below

 

SQL Server : The request failed or the service did not respond in a timely fashion.Consult the event log or other application error logs for details

 

But the sql server service is not starting up and i got the error message as shown below
The request failed or the service did not respond in a timely fashion.Consult the event log or other application error logs for details.”

 

SQL Server : The request failed or the service did not respond in a timely fashion.Consult the event log or other application error logs for details

 

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

First i will show you how you can go to application log and view the details of the error.
You need to right click on the Computer and select Manage option as shown below.

 

SQL Server : The request failed or the service did not respond in a timely fashion.Consult the event log or other application error logs for details

Expand Server Manager Diagnostics,Event Viewer,Window Logs,Application and view the error where the source is MSSQLSERVER as shown in the image below. “The system cannot find the file specified”. It means master.mdf isn’t available and without master DB SQL Server will not be started.

 

SQL Server : The request failed or the service did not respond in a timely fashion.Consult the event log or other application error logs for details

 

Another 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 Manager and go to the properties as shown below.

 

SQL Server : The request failed or the service did not respond in a timely fashion.Consult the event log or other application error logs for details

 

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

 

SQL Server : The request failed or the service did not respond in a timely fashion.Consult the event log or other application error logs for details

 

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

 

SQL Server : The request failed or the service did not respond in a timely fashion.Consult the event log or other application error logs for details

 

It is also showing the same error message which we have seen in the application log as shown below.

 

SQL Server : The request failed or the service did not respond in a timely fashion.Consult the event log or other application error logs for details

Now go to the location which is specified by Error Log or Application Log and rename master_renamed.mdf back to master.mdf as shown below.

 

SQL Server : The request failed or the service did not respond in a timely fashion.Consult the event log or other application error logs for details

Now go to SQL Server Configuration Manager and start the SQL Server(MSSQLSERVER) and this time it will start up.

 

SQL Server : The request failed or the service did not respond in a timely fashion.Consult the event log or other application error logs for details

2 thoughts on “The request failed or the service did not respond in a timely fashion.Consult the event log or other application error logs for details–How to troubleshoot it

Leave a Reply

Your email address will not be published.