Fix – Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

This error message is due to the server setting of Remote Connection Query Timeout. The default is 600 seconds, or 10 minutes.

[cc lang=”sql”]
EXEC SP_CONFIGURE ‘remote query timeout’, 1800
reconfigure
EXEC sp_configure

EXEC SP_CONFIGURE ‘show advanced options’, 1
reconfigure
EXEC sp_configure

EXEC SP_CONFIGURE ‘remote query timeout’, 1800
reconfigure
EXEC sp_configure
[/cc]

After making this change, make sure to close the window and create a new connection in order to inherit the new query timeout settings.

23 comments
Saiprasad Kedare 29 Feb 2016 at 1:38 pm

SQL server time out issue from remote machine
solved by executing bellow querys

EXEC SP_CONFIGURE ‘remote query timeout’, 1800
reconfigure
EXEC sp_configure

EXEC SP_CONFIGURE ‘show advanced options’, 1
reconfigure
EXEC sp_configure

EXEC SP_CONFIGURE ‘remote query timeout’, 1800
reconfigure
EXEC sp_configure

Phanindra Sharma 23 Mar 2015 at 10:49 am

I have the same problem.
i’m facing this with a precompiled software.
Earlier it was working well but now it’s giving the error “Query Timeout Expired”.
Can anyone help me

Anant Naik 18 Mar 2015 at 4:11 pm

hi
I am using Dot net application with Sql 2008 server as back end
i am getting problem of slow running the application in client machine
also loading of crystal report is very slow

dKraft 08 Jan 2015 at 9:47 pm

This worked just great! I modified a huge table with an ntext field into nvarchar() using this series of command first. Thanks!

EXEC SP_CONFIGURE ‘remote query timeout’, 1800
reconfigure
EXEC sp_configure

EXEC SP_CONFIGURE ‘show advanced options’, 1
reconfigure
EXEC sp_configure

EXEC SP_CONFIGURE ‘remote query timeout’, 1800
reconfigure
EXEC sp_configure

Kathir 11 Sep 2014 at 6:43 am

Thanks,Now my query it works

santosh 27 Aug 2014 at 12:09 pm

Thank you so much Derek your solution has just saved me. I was really struggling with a big stored procedure which was taking a lot of time to get the output and server used to expire always.

kalaimadhan 18 Sep 2013 at 11:52 am

thanks a lot friend…. Its very useful my work…..

Karl 20 Aug 2013 at 7:32 pm

FYI: I had increase the time for QUERY WAIT to 200 sec, but then I found the error in my criteria selection. After fixing it, the view needed 24 sec. to execute. When I reversed the 200 sec setting to -1, the view executed in 18 sec….

manish sharma 12 Jul 2013 at 3:47 am

hello sir

i read your article but my problem is not solving pls help me and send me suitable answers

timeout expired. the timeout period elapsed prior to completion

plz plz

Larry Huffman 28 Jun 2013 at 3:31 pm

This worked to fix my problem. The thing to remember is this is not really a fix in the sense that something is changing to make your query run better. You are merely telling the DB to give it more time to complete. In many cases that is all that is needed, but if you have a query that is too long or has other inherent problems, increasing a time out will not fix that.

santosh 27 Aug 2014 at 12:10 pm

I totally agree with you … great article..

Raj 18 Apr 2013 at 8:12 pm

http://support.microsoft.com/kb/915850/en-us sp_fulltext_service ‘verify_signature’, 0;

vipin 15 May 2012 at 10:31 pm

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

ISAHACK 19 Apr 2012 at 6:39 am

THANKS! A LOT!!! WORK FOR ME!

moges 17 Apr 2012 at 2:03 pm

This script solved my problem and my application became really fast.

Thank you!

Sophia Hibbard 23 Jan 2013 at 9:14 pm

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Can you send me the codes ? how do you fix the issues ? Thanks. Sophia

Servet 22 Dec 2011 at 7:32 am
saritha 21 Dec 2011 at 3:59 am

Nice solution, its working for me.

Thanks for your support.

puja 13 Sep 2011 at 12:31 am

Is there any way apart from increasing timeout? mindgrillq.blogspot.com

Derek Dieter 16 Sep 2011 at 12:20 pm

Hi Puja,

The only other way would be to speed up the query.

Derek

pavlo 07 Jul 2011 at 7:46 pm
Simon 15 Jun 2011 at 6:39 am

I still have time-out, “The timeout period elapsed prior to completion of the operation or the server is not responding.” after I changed “remote query timeout” from 600 default to 100000000

vivek 26 Jun 2013 at 6:36 am

or add commandtimeout=0 its for unlimited connection

ex. command.Connection = GenConnection()
commandReader.Connection = command.Connection
command.CommandTimeout = 0

Featured Articles

 Site Author

  • Thanks for visiting!
css.php