Connectivity issue when trying to connect Alteryx 2022.1 to Azure SQL DB

Question

I've been trying to read data from Azure SQL DB (SQL Server). I've used ODBC 17 Driver for SQL Server and this worked in the past. But I haven't been able to connect to the SQL Server recently. I am using a SQL user and password with db_owner as the role, and the login works for me when used with the database.

The workflow however fails after a (sometimes very) long wait of 20 min - 4 hrs with the below error. I have also tried using the OLE DB connector, but didn't work.

Has anyone else faced such an issue? How did you solve it?

Alteryx connection issue SQL DB.PNG

caltang · Accepted Answer

Hi @akspande,

I believe this user had the same issue: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Error-on-Data-Stream-Out/td-p/777041

Perhaps you can replicate what they did and report back here.

Hope this helps.

Best,

Cal