topic Re: Errors trying to connect to Fabric SQL Data warehouse from SQLServer Management Studio in Data Warehouse

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

Anonymous — Tue, 09 Apr 2024 15:46:53 GMT

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

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

vanessafvg — Tue, 09 Apr 2024 18:06:54 GMT

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

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

Anonymous — Wed, 10 Apr 2024 13:44:19 GMT

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

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

Anonymous — Mon, 15 Apr 2024 16:13:14 GMT

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.

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

Anonymous — Tue, 16 Apr 2024 15:33:30 GMT

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

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

Anonymous — Tue, 16 Apr 2024 15:43:41 GMT

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.

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

Anonymous — Tue, 16 Apr 2024 16:26:46 GMT

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

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

Anonymous — Wed, 17 Apr 2024 17:00:32 GMT

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