Error 22424 when using SQL endpoint from Lakehouse

[BluechipDA]

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.

[BluechipDA · Accepted solution]

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

[Anonymous]

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]

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]

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 .