Forum Discussion

BluechipDA's avatar
BluechipDA
New Member
2 years ago
Solved

Error 22424 when using SQL endpoint from Lakehouse

  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 h...
data warehouse
one lake
  • BluechipDA's avatar
    BluechipDA
    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.

Anonymous's avatar
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's avatar
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's avatar
    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 .