How to Fix:Error: Microsoft ODBC Driver 18 for SQL Server : SSL Provider: [error:1416F086:SSL routines:tls_process_server_certificate:certificate verify failed:self signed certificate].

Question

I followed the documentation: https://docs.microsoft.com/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server to run sql server on my uḃuntu vm 22.04 All the packages and dependencies are installed my mssql-server is also running but when i want to connect with my server after entering the password am getting the error.

Sqlcmd: Error: Microsoft ODBC Driver 18 for SQL Server : SSL Provider: [error:0A000086:SSL routines::certificate verify failed:self-signed certificate]. Sqlcmd: Error: Microsoft ODBC Driver 18 for SQL Server : Client unable to establish connection. For solutions related to encryption errors, see https://go.microsoft.com/fwlink/?linkid=2226722.

Answer 1

Hi @Dipanjan Das

Try adding TrustServerCertificate=yes; to your connection string.

Best regards,

Cosmog Hong

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi, @Dipanjan Das Welcome to Microsoft Q&A thanks for posting your question.

You can either install a certificate on your server, follow the document here (https://learn.microsoft.com/en-us/sql/linux/sql-server-linux-encrypted-connections) or disable encryption with -No option (https://learn.microsoft.com/en-us/sql/connect/odbc/linux-mac/connecting-with-sqlcmd)

Regards

Geetha