Connect to Fabric Lakehouse SQL Endpoint

What Happened?

Issue:

Unable to connect to the Fabric SQL endpoint from Monitor and Integrate.

Impact:

Unable to validate the connection.

Error:

Connection Validation Failed.

connect1.png

How can you fix it?

Resolution

The ‘tcp’ parameter in the connection string needs to be removed to validate the connection. Edit your connection to remove the ‘tcp’ parameter.

tcp in message