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

[FergusN]

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...

[v-nikhilan-msft]

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.

[FergusN]

Hi 

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

Thanks

F

[v-nikhilan-msft · Accepted solution]

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