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?

[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? 

[MZ]

Same issue here.

[cbuckels13]

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

[MZ]

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!

[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.