Timeout error on Alteryx gallery for SQL connection

Question

Dear Colleagues,

I need your advice regarding the error I receive on Alteryx gallery for scheduled workflows with SQL connections.

The full message is as below. I receive it randomly for some workflows for some days ( Each day error for different workflow, and also on some days without any errors). I am wondering why this is happening randomly and how this can be fixed?

Error SQLDriverConnect: [Microsoft][SQL Server Native Client 11.0]TCP Provider: Timeout error [258]. [Microsoft][SQL Server Native Client 11.0]Login timeout expired[Microsoft][SQL Server Native Client 11.0]Unable to complete login process due to delay in login response

Thank you in advance!

Asia

JagdeeshN · Accepted Answer

Hi @joannasokolowska ,

This seems to originate on the SQL Server side due to a timeout setting.

On gallery sometimes due to network delay i have encountered the same.

Can you please check with your database admin if they can increase the timeout value on the SQL server side?

Best,

Jagdeesh