Sqlcmd: Error: Microsoft ODBC Driver 18 for SQL Server:SSL Provider: [error:0A000086:SSL routines::certificate verify failed:self-signed certificate]
00:13 27 Oct 2023

I'm creating instance of SQL Server in a Docker container.

$ sudo docker run -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=Adminxyz22#" -p 1433:1433 --name sql3  -d mcr.microsoft.com/mssql/server:2022-latest
bd7603e0df04a9ec23cfb089ee43bf5723ab4f1c881aefaf896c9ef11d2d909f

When I do the sudo docker ps

$ sudo docker ps -a
CONTAINER ID   IMAGE                                        COMMAND                  CREATED          STATUS                        PORTS                                            NAMES
285722569f6e   mcr.microsoft.com/mssql/server:2022-latest   "/opt/mssql/bin/perm…"   9 minutes ago    Exited (0) 6 minutes ago 

Now I'm trying to connect to Docker container SQL Server using sqlcmd I get this error:

sqlcmd -S localhost,1433 -U SA -P "Adminxyz22#"
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.

When I login into docker container and execute sqlcmd it is working fine.

$ sudo docker exec -it bd7603e0df04 /bin/bash
mssql@bd7603e0df04:/$ /opt/mssql-tools/bin/sqlcmd -S localhost -U SA -P "Adminxyz22#"
1>

How can I fix the error?

sql-server sqlcmd