Connection to Microsoft Azure SQL Datebase
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
- Labels:
- Server
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @EladLevy! I'm running into the same problem. Did you find a solution?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Same issue here.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This just started happening to me as well. Everything was fine and then not. Any updates for a fix?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Same issue here - worked fine until Friday last week
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
