I have created two easy to use scripts to install docker and get SQL Server running.
InstallSqlServerPart1.sh
#!/bin/bash
# Create directory
mkdir -p ~/docker/sqlserver
# Move into directory
cd ~/docker/sqlserver
# Create docker-compose.yml
cat <<EOF > docker-compose.yml
services:
sqlserver:
image: mcr.microsoft.com/mssql/server:2022-latest
container_name: sqlserver
environment:
ACCEPT_EULA: "Y"
MSSQL_SA_PASSWORD: "Str0ng!Passw0rd123"
MSSQL_PID: "Express" # If this ever fails, use "Developer"
ports:
- "1433:1433"
volumes:
- sqlserver_data:/var/opt/mssql
restart: "no"
volumes:
sqlserver_data:
EOF
echo "docker-compose.yml created in ~/docker/sqlserver"
sudo apt update
sudo apt install docker.io docker-compose -y
sudo systemctl enable docker
sudo systemctl start docker
sudo usermod -aG docker $USER
docker --version
# Create directory
mkdir -p ~/docker/sqlserver
# Move into directory
cd ~/docker/sqlserver
# Create docker-compose.yml
cat <<EOF > docker-compose.yml
services:
sqlserver:
image: mcr.microsoft.com/mssql/server:2022-latest
container_name: sqlserver
environment:
ACCEPT_EULA: "Y"
MSSQL_SA_PASSWORD: "Str0ng!Passw0rd123"
MSSQL_PID: "Express" # If this ever fails, use "Developer"
ports:
- "1433:1433"
volumes:
- sqlserver_data:/var/opt/mssql
restart: "no"
volumes:
sqlserver_data:
EOF
echo "docker-compose.yml created in ~/docker/sqlserver"
sudo apt update
sudo apt install docker.io docker-compose -y
sudo systemctl enable docker
sudo systemctl start docker
sudo usermod -aG docker $USER
docker --version
InstallSqlServerPart2.sh
#!/bin/bash
cd ~/docker/sqlserver
docker compose up -d
docker compose logs -f
After creating the two scripts, make them executable.
chmod +x InstallSqlServerPart1.sh
chmod +x InstallSqlServerPart1.sh
Then execute the first one:
./InstallSqlServerPart1.sh
Logout
Log back in
Then execute the second one:
./InstallSqlServerPart2.sh
Connect with this connection string:
Server=localhost,1433;Database=bedbrigade;User Id=sa;Password=Str0ng!Passw0rd123;Encrypt=True;TrustServerCertificate=True;Docker Cheat Sheet
docker compose logs –f # Watch logs to see it running
docker compose ps # Check if running
docker compose stop # stop
docker compose start # start again
docker compose up -d # create + start
docker compose down # remove container, keep data
docker compose down -v # remove container + delete data
