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
Solved! Go to 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
Thanks for the suggestion! we will test it with the proper team and check server properties.
Thanks!
asia