SQL EXECUTION TIMEOUT ERROR on SSMS v21

Question

Hello,

When queries that take longer than 30 minutes are executed, the following error pops up:
'Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding'.

I am currently using SSMS version 21.5.14.
I do get results for simpler queries that run within 30 seconds.

I also set the Execution time-out setting to 0 seconds (no timeout) and to 60000 seconds as a test, and I still get the error.

Did someone else experience this too? And is there a fix for this?

Thanks in advance.

Gr,
Manish

Answer 1

To work around the problem, try to save the queries, restart Management Studio, and set the timeouts in the new Connect dialog (Advanced button):

• https://developercommunity.visualstudio.com/t/Execution-Timeout-Expired/10963347

It seems that the problem is resolved, but the fix is not available yet.

Answer 2

As Viorel said, the issue has been fixed - and the fix was released today, a couple of hours after Viorel made his post. Make sure that you install SSMS 21.6.17.

Also, observe this from the release notes:

	Reinstated the execution timeout default value to 0. See Execution Timeout Expired. Note: this change doesn't update the execution timeout value for existing connections. To resolve this issue, delete all previously created connections or manually update the execution timeout to 0.