Workflow that is started automatically (by other workflow/scheduled), with an Execute SQL action is failing to run, sometimes with explicit SQL timeout errors, and other times without.
- Copy your SQL query from the Execute SQL action.
- Open SQL Management Studio and run the query against the associated database.
- If the query is taking close to, or longer than 15 seconds, this could result in a SQL timeout.
You can resolve this timeout issue by extending that connection timeout value inside the Execute SQL action. Append Connect Timeout=XX at the end of the connection string. For example: