Forum Discussion
Connecting to fabric SQL endpoint from SSMS
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? ...
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)
Hi , Anonymous
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?