Last week I created my first Datalake using Fabric. After getting some data in it I wanted to start altering the data using SSMS but here I faced an issue. After fetching the SQL string from the endpoint object I get the error message below. I've tried to connect with Azure Data Studio instead, and also to create a new Lakehouse, still the same error.
So my issue was that the internal zScaler from my company was blocking a specific port needed to connect to the SQL string outside of fabric. I could access it from the office or when I turned of zScaler for a few minutes. The issue was resolved quite easily with a few changes to the rules in zScaler itself.