Connection to Microsoft Azure SQL Datebase

EladLevy

Hi everybody,

I try to connect to Microsoft Azure SQL Datebase OleDB.

Then I click on Microsoft OLE DB Driver 19 for SQL Server.

After that, I type the server name and press on Universal with MFA support.

then, press on Test Connection and It looks Succeeded.

But, after this, I press on OK and I get an ERR. "Error, Open returned 0x80040e21".

What am I doing wrong?

Server

Accepted answers

ChristianElgaard

Yeah - it is quite frustrating. I managed to resolve the issue connecting by downgrading the Microsoft OLE DB Driver for SQL Server from 19.x to 18.7.4 I have been told that a dedicated Fabric connector is on its way.

All comments

TimN

The error looks similar to this:

https://stackoverflow.com/questions/37714783/oledb-error-code-0x80040e21

Maybe there is an advanced setting to address the issue if it's related to data types. I'd reach out to Alteryx Support.

Hope that helps.

Gem

Hi @EladLevy! I'm running into the same problem. Did you find a solution?

Same issue here.

cbuckels13

This just started happening to me as well. Everything was fine and then not. Any updates for a fix?

We work around this by using a service account and a manual OLEDB connection string specified in the Alteryx Server Gallery, which we sync. This is not ideal.

ChristianElgaard

Same issue here - worked fine until Friday last week

Undertak

Can you share the details of your manual oledb connection string?

I'm trying to connect to Azure for the first time and this is really frustrating!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703