Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
FergusN
Frequent Visitor

SSMS connection was successfully established with the server, but then an error Error Number: 10054

Hi 

 

Getting this error when trying to connect to microsoft Fabric SQL endpoint from SSMS. This was working last week and now the engineering team can no longer connect as of today. 

 

Any ideas ? Thanks

 

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.) (Framework Microsoft SqlClient Data Provider)

 

------------------------------

For help, click: https://docs.microsoft.com/sql/relational-databases/errors-events/mssqlserver-10054-database-engine-...

 

------------------------------

Server Name: XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

Error Number: 10054

Severity: 20

State: 0

 

 

https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/connect/tls-exist-connection-clos...

 

1 ACCEPTED SOLUTION

Hi @FergusN ,
Glad your issue got resolved. Please continue using Fabric Community for resolving your queries.

View solution in original post

3 REPLIES 3
v-nikhilan-msft
Community Support
Community Support

Hi @FergusN ,
Thanks for using Fabric Community.
Can you please try reconnecting to SSMS and let me know if you are facing the same issue?
As I tried to repro at my end there is no such issue in connecting to SSMS. Hence please confirm if the issue still persists.

Hi 

 

The issue seems to have magically resolved itself as of late yesterday. Hopefully this is not a recurrent problem 

 

Thanks

 

F

Hi @FergusN ,
Glad your issue got resolved. Please continue using Fabric Community for resolving your queries.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

March 2024  FBC Gallery Image

Fabric Monthly Update - March 2024

Check out the March 2024 Fabric update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.