wachira90/sqlserver repository overview

⁠SQL Server 2017 2019 2022

⁠RUN COMMAND Version Express

docker run --name sql \
-e SA_PASSWORD=Pwd14331433 \
-e SQLSERVER_DATABASE=testdb \
-e SQLSERVER_USER=wachira90 \
-e SQLSERVER_PASSWORD=Pwd14331433 \
-p 1433:1433 -d wachira90/sqlserver:2017

⁠RUN COMMAND Version Developer

docker run --name sql \
-e SA_PASSWORD=Pwd14331433 \
-e SQLSERVER_DATABASE=testdb \
-e MSSQL_PID=Developer \
-e SQLSERVER_USER=wachira90 \
-e SQLSERVER_PASSWORD=Pwd14331433 \
-p 1433:1433 -d wachira90/sqlserver:2017

docker run -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=xxxxxxxxxxx' -e 'MSSQL_PID=Express' -p 1433:1433 -d wachira90/sqlserver:dev

Developer : This will run the container using the Developer Edition (this is the default if no MSSQL_PID environment variable is supplied)

Express : This will run the container using the Express Edition

Standard : This will run the container using the Standard Edition

Enterprise : This will run the container using the Enterprise Edition

EnterpriseCore : This will run the container using the Enterprise Edition Core : This will run the container with the edition that is associated with the PID

⁠CHECK RUN BY

docker ps -a

⁠START STOP

docker [stop|start|restart] sql

⁠warning:

all your password must match the mssql rule : at least 8 chars, with lower, upper and digits
and docker instance must have at least 3192Mo of memory allocated.

⁠VLOUMES

-v /sqlserver/db:/var/opt/mssql