I keep receiving this connection error when using the sql connection string from fabric's lakehouse. I'm using the Azure Active directory - Universal with MFA authintication as well. any help is appreciated.

Thank you for the reply! I realized I was not using the latest version of sql and that ended up being the issue.

Error 22424 when using SQL endpoint from Lakehouse

Anonymous
Not applicable
2 years ago
Hi BluechipDA ,

Thanks for using Fabric Community.

I was able to connect to Fabric Lakehouse and execute queries via SSMS (SQL Server Management Studio) using Azure Active Directory - MFA without any issue.

Fabric - SQL Endpoint:

SSMS (SQL Server Management Studio):

Can you please share few more details of your issue like what you are trying to acheive? when you are facing this issue?

I would be able to guide you better if you can share these details.
- Anonymous
  Not applicable
  2 years ago
  Hello BluechipDA ,
  
  We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .
  In case if you have any resolution please do share that same with the community as it can be helpful to others .
  Otherwise, will respond back with the more details and we will try to help .
  - Anonymous
    Not applicable
    2 years ago
    Hi BluechipDA ,
    
    We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .
    In case if you have any resolution please do share that same with the community as it can be helpful to others .
    Otherwise, will respond back with the more details and we will try to help .
BluechipDA
New Member
2 years ago
Thank you for the reply! I realized I was not using the latest version of sql and that ended up being the issue.