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.