Hi
we are trying to connect to a Microsoft azure sql server and keep hitting problems, this is the error we are receiving is attached.
We can access the database using sql server management and the same credentials however we hit a roadblock when using alteryx.
any help would be much appreciated.
we have the ODBC driver 11 installed. we are quite new to this so do not know what more we can do
thanks
Ashley
Solved! Go to Solution.
I managed to get this working
Hi Ashley,
What did you do to get it working?
I'm connecting to an Azure server using the 'SQL Server Native Client 11.0' ODBC driver, and the performance has been awful. Wondering if you found a different solution?
Thanks,
-Adrian
Hi Adrian
unfortunately not, I am using the native client odbc driver as well. in the end it was a permissions issue for us so required the DB owner to update our credentials.
Sorry I don't have another solution for you.