Getting timeout when running a stored procedure which makes rest API calls - How to increase timeout?

521 Views Asked by At

A customer is on SQL Server 2017 and is executing a stored procedure that makes an API call to a server and fetches data.

Sometimes (when the API call is intensive on the remote server and takes too long to return data) the call times out at the customer's end around the 30 second mark.

The error they receive is:

0x80072EE2 msxml6.dll The operation timed out

Upon looking online, this seems like a default timeout on the xmlhttp client that SQL Server uses.

How to increase the timeout pertaining to the xmlhttp client? Would increasing the stored procedure timeout take care of this?

0

There are 0 best solutions below