I have installed SQL Server 2017 for Linux on my Debian machine using the .deb package provided by Microsoft.
My issue is noway I can connect to it either by SQL Server Management Studio on Windows or Azure Data Studio on Mac.
With SSMS it gives me the following error:
A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - An existing connection was forcibly closed by the remote host.)
I have tried many things including adding a self-signed certificate but it does not work.
The funny thing is I am able to connect to it using a 3rd party software named Valentina Studio but not with any MS Client application.