How to fix error when connecting to MS SQL Server in ASP Net Core application on Ubuntu?

Question

ASP.NET

Hosted an ASP Net Core application on ubuntu 20.10. I start and at the moment when I need to connect to the database, an error occurs:

SqlException: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: SSL Provider, error: 31 - Encryption(ssl/tls) handshake failed)

Communication with the database is organized through the Entity Framework. Connection string: Server=172.172.172.120;Database=clients_si;User Id=*****;Password=******;
Although on a windows machine everything works fine. Please tell me how to fix this error?

Answer 1

According to this post:

(provider: SSL Provider, error: 31 - Encryption(ssl/tls) handshake failed

It is possible that the system lacks the necessary trusted certificate.

Answer 2

Read:
https://docs.microsoft.com/en-us/sql/connect/ado-n...