Sqlcmd: Error: Microsoft ODBC Driver 18 for SQL Server:SSL Provider: [error:0A000086:SSL routines::certificate verify failed:self-signed certificate]
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?