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.

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.

Related Posts:
»Using sp_configure
»Using OpenQuery
»Insert Stored Procedure Results Into Table
»Is Job Running?
»Configure Change Data Capture Settings
»Using sp_addlinkedserver
»Add User to Role
»Rename Column
»SQL Server SPID – What is it?
»Using sp_rename

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

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