SQL Server: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding

SQL Server: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding

The "Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding" error may occur when the command took too long to execute or the server stopped responding during the command.

To resolve the issue, please increase the "Command Timeout"/"Connection Timeout" values for your SQL Server connection. For this, switch to the Connections page and find your SQL Server connection. Then click Edit, open Advanced Settings below, and then set bigger values (5000) for both parameters or set 0 to have it without timeout.  


Also, kindly check the timeout settings at your SQL server side. Please refer to this topic with a similar issue for more details.

    • Related Articles

    • MySQL: Resolving "Lost connection to MySQL server during query" Error

      To resolve the "Lost connection to MySQL server during query" error, please follow the steps below: Go to the Connections page and select your MySQL connection. Click Edit. In the Connection Editor, go to Advanced, then increase or set to 0 the ...

    • Automation: Task Limit Reached

      The "You have reached the limit of tasks" error in Automation indicates that you have exceeded the number of billed tasks allowed in your pricing plan for the current billing period. A billed task is any successful execution of an Action component ...

    • Salesforce: Expired access/refresh token

      If you see an "expired access/refresh token" error, your Salesforce OAuth connection is invalid due to token expiration or revocation. Please open your Salesforce connection, sign in again, and save it. Test the connection to confirm it works. This ...

    • Skyvia Query: Easily Verify Data in Your Connection!

      Please follow the steps below to query your data in Skyvia Query: Log in to Skyvia and navigate to + Create New → Query. Select an existing connection or establish a new one for your data source. Choose the desired table or object from the Connection ...

    • PostgreSQL: A call to SSPI failed, see internal exception

      "A call to SSPI failed, see internal exception" indicates that the security protocol (SSL/TLS) used in your PostgreSQL connector does not match the version supported by your server. To resolve this, we recommend trying different SSL/TLS protocol ...