Fabric Lakehouse >> SQL Analytics end point >> not able to connect with SSMS | Cannot connect to ---

[abagarw_microso]

Hello All,
I am trying to connect to SQL Endpoint of a Fabric Lakehouse via SSMS to do some analysis.

I keep getting this error - 

TITLE: Connect to Server
------------------------------

Cannot connect to xxxxxxxxxxxxxxxxxxxxx4-xxxxxxxxxxxxxxxx.vfds-datawarehouse.fabric.microsoft.com.

------------------------------
ADDITIONAL INFORMATION:

A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) (Microsoft SQL Server, Error: 10054)

[Anonymous]

Hi @abagarw_microso ,

Is my follow-up just to ask if the problem has been solved?

If so, can you accept the correct answer as a solution or share your solution to help other members find it faster?

Thank you very much for your cooperation!

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[Anonymous]

Hi @abagarw_microso ,

Thank you for your interest in this case.

I can't reproduce your error, I can successfully connect to lakehouse without checking the "Trust server certificate" option.

When I enter the SQL endpoint string and configure the authentication method, I click "connect" and it will jump to the web page asking me to log in to my account. After logging in successfully, there will be this prompt.

At this time, I return to SSMS and can see that I have successfully connected.

Here are some of my suggestions:

Make sure you have the correct SQL connection string. Navigate to your workspace and select Lakehouse>>Settings>>click the “Copy” button in the SQL endpoint String box to copy it to the clipboard.

Make sure you have the permissions you need to access Lakehouse and its SQL endpoints.

Open TCP port 1433 on your firewall.

In SSMS, go to View >> Select Error list and output to see the detailed error messages and queries that were triggered, which can help determine if there are any permission issues or other errors.

This official document has examples of connecting to SQL endpoints, and it mentions prerequisites, considerations that may be helpful to you:

Connectivity to data warehousing - Microsoft Fabric | Microsoft Learn

If you have any other questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[Shanmukh_SS]

If this is in your Org laptop, I used to face this when I have Zscaler or any similar application which isn't allowing to connect and gives similar error 

[prasbharat]

Hi,

Please check for below to troubleshoot connection issues in SSMS

• In SSMS, go to the connection properties and select the checkbox "Trust server certificate". Then try connecting again.
• Ensure you're using SSMS 18.12 or later to support Fabric endpoints.
• Use Azure Active Directory (AAD) authentication, as SQL Authentication is not supported for Fabric SQL Endpoints.
• Ensure the domain fabric.microsoft.com or the endpoint’s IP is allowed in your firewall settings.
• Confirm TLS 1.2 or higher is enabled on your system.

You can check this link as well: https://learn.microsoft.com/en-us/fabric/data-warehouse/connectivity

If this post helps you resolve the issue, please consider accepting it as the solution to help other members find it more quickly. If you still have additional questions, feel free to let me know, and I’ll be happy to assist further. Thanks a lot!

[Surjya13]

Select the checkbox "Trust server certificate" and then give it a try.