Install SQL Server on Docker

For these steps I use Podman rather than Docker on my Debian machine, to get a serviceless installation that does not need to run as root.

Pulling the SQL Server Docker image

The list of downloadable images is here.

You can pick the edition through the environment variables, with MSSQL_PID — for instance -e "MSSQL_PID=Developer" for the Developer edition.

podman pull mcr.microsoft.com/mssql/server:2022-latest

podman run -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=Admin12345!" -e "MSSQL_PID=Developer" -p 1433:1433 --name sql_server_2022 -d mcr.microsoft.com/mssql/server:2022-latest

Check that the container is running:

podman ls

Getting an SSL certificate with Certbot

sudo certbot certonly --standalone --preferred-challenges http -d sql.pachadata.com