Issue with connecting to SQL Server 2017 on Linux

%3CLINGO-SUB%20id%3D%22lingo-sub-271331%22%20slang%3D%22en-US%22%3EIssue%20with%20connecting%20to%20SQL%20Server%202017%20on%20Linux%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-271331%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20installed%20SQL%20Server%202017%20for%20Linux%20on%20my%20Debian%20machine%20using%20the%20.deb%20package%20provided%20by%20Microsoft.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20issue%20is%20noway%20I%20can%20connect%20to%20it%20either%20by%20SQL%20Server%20Management%20Studio%20on%20Windows%20or%20Azure%20Data%20Studio%20on%20Mac.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWith%20SSMS%20it%20gives%20me%20the%20following%26nbsp%3Berror%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EA%20connection%20was%20successfully%20established%20with%20the%20server%2C%20but%20then%20an%20error%20occurred%20during%20the%20login%20process.%20(provider%3A%20SSL%20Provider%2C%20error%3A%200%20-%20An%20existing%20connection%20was%20forcibly%20closed%20by%20the%20remote%20host.)%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20tried%20many%20things%20including%20adding%20a%20self-signed%20certificate%20but%20it%20does%20not%20work.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20funny%20thing%20is%20I%20am%20able%20to%20connect%20to%20it%20using%20a%203rd%20party%20software%20named%20%3CSTRONG%3EValentina%20Studio%3C%2FSTRONG%3E%20but%20not%20with%20any%20MS%20Client%20application.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

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.