Timeout error on Alteryx gallery for SQL connection

[joannasokolowska]

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 solution]

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

[joannasokolowska]

Thanks for the suggestion! we will test it with the proper team and check server properties. 

Thanks!

asia