Connecting to fabric SQL endpoint from SSMS

Question

Hi,I'm unable to connect to my fabric SQL endpoint from SQL Server Management Studio.This is supposed to be possible right?Error message below.Anyone know what I need to get this working?Thanks&nbsp;&nbsp;

marcosvin · Answer

Hello!&nbsp;From the error message it appears you are executing an INSERT command in a lakehouse, which is not supported. Lakehouse SQL Endpoint only allows SELECT queries. To modify data you need to create flows using dataflows and pipelines or use commands directly in Spark notebooks.What is SQL endpoint for a lakehouse? - Microsoft Fabric | Microsoft Learn&nbsp;To perform DML operations use warehouses instead of lakehouses.

anonymous · Answer

That doesn't explain it but agree it's odd that INSERT is mentioned in the error text.The error happens during initial attempt to establish a connection to the SQL endpoint (shown below)&nbsp;

v-yueyunzh-msft · Answer

Hi ,&nbsp;&nbsp;Anonymous&nbsp;
Are you able to connect successfully now? According to your error message "INSERT is not a supported statement type", it means that the SQL endpoint does not support the insert statement.
Creating, altering, and dropping tables, and insert, update, and delete are only supported in Warehouse in Microsoft Fabric, not in the SQL Endpoint of the Lakehouse.
And i test it in my side , i can connect it without any error code .
Did you choose to execute statements or open some windows when you connected?
&nbsp;
For this , you can also refer to :T-SQL surface area - Microsoft Fabric | Microsoft Learn
Connectivity to data warehousing - Microsoft Fabric | Microsoft Learn
&nbsp;

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!&nbsp;
&nbsp;
Best Regards,
Aniya Zhang
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly

andyddc · Answer

What's your version of SSMS? Can you try updating to the latest version and try again?

Forum Discussion

Connecting to fabric SQL endpoint from SSMS

Related content

sql endpoint connection

Can't connect to a SQL endpoint from MS Fabric Lakehouse

Fabric Connections

Connect Cognos to Fabric SQL Endpoint - Lakehouse using JDBC

JDBC connection to Fabric Lakehouse SQL endpoint using notebook