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

[akspande]

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?

[caltang · Accepted solution]

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

[akspande]

Thanks, I checked the SQL query, it needed performance tuning. Now the read is working