Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
BluechipDA
New Member

Error 22424 when using SQL endpoint from Lakehouse

BluechipDA_0-1701189751460.png

 

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.

1 ACCEPTED SOLUTION
BluechipDA
New Member

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

View solution in original post

4 REPLIES 4
BluechipDA
New Member

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

v-gchenna-msft
Community Support
Community Support

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:

vgchennamsft_1-1701247663776.png

 

SSMS (SQL Server Management Studio):

vgchennamsft_0-1701247553069.png

 

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.


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 .

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 .

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

March 2024  FBC Gallery Image

Fabric Monthly Update - March 2024

Check out the March 2024 Fabric update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Kudoed Authors