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.
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
After making this change, make sure to close the window and create a new connection in order to inherit the new query timeout settings.
Popular search terms:
- Timeout expired The timeout period elapsed prior to completion of the operation or the server is not responding
- The timeout period elapsed prior to completion of the operation or the server is not responding
- timeout expired the timeout period elapsed
- timeout expired the timeout period elapsed prior to completion of the operation
- the timeout period elapsed prior to completion of the operation
Thanks
Nice solution, its working for me.
Thanks for your support.
Is there any way apart from increasing timeout? mindgrillq.blogspot.com
Hi Puja,
The only other way would be to speed up the query.
Derek
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
j