Errors trying to connect to Fabric SQL Data warehouse from SQLServer Management Studio

[Anonymous]

I'm using the connection string provided by fabric Settings but get this error when I try to connect in SSMS using Azure Active Directory with MFA to authenticate

[Anonymous]

Hi, I tried all of that but it still does not work, I don't see any messages at all written in the Output or Error List. My user that I am trying to connect to is the owner of the Fabric Data Warehouse and Lakehouse.

[Anonymous]

Hi @Anonymous 
I tried to repro the scenario, but didn't face any issue while connecting to SSMS. 

I'd recommend reaching out to our support team by raising a support ticket so an engineer can take a closer look at this scenario:

https://support.fabric.microsoft.com/support

I am unable to repro this issue on my end, so an investigation by an engineer would be the best path forward. Please provide the support ticket details here, so that we can track it for internal purposes.

Thanks

[Anonymous]

Hi @Anonymous 
We haven’t heard from you on the last response and was just checking back to see if you got a chance to create a support ticket. If yes please provide the details here. Otherwise, will respond back with the more details and we will try to help.
Thanks

[Anonymous]

Hi Vanessa, there is no code involved, I get this error when trying to connect

[Anonymous]

Hi @Anonymous 
Are you still facing this issue?
If yes please refer to this link:  Solved: Connecting to SQL end point in Fabric from SSMS - Microsoft Fabric Community

Hope this helps. Please let me know if you have any further queries.

[Anonymous]

Hi @Anonymous 
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. Otherwise, will respond back with the more details and we will try to help.
Thanks

[vanessafvg]

can you share your code, as its telling you the method you are using is not supported for inserts?