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

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

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

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

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

Thanks,Now my query it works

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.

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

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

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

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

Reply to this comment

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

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

THANKS! A LOT!!! WORK FOR ME!

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

Reply to this comment

Thanks

Nice solution, its working for me.

Thanks for your support.

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

Reply to this comment

i too 🙁

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

Reply to this comment