docker-compose.sql-server.yml

docker-compose.sql-server.yml

version: "3.8"

services:
  sql-server:
    container_name: sql-server
    image: mcr.microsoft.com/mssql/server:2019-latest
    ports:
      - "1434:1433"
    environment:
      SA_PASSWORD: "myPassw0rd"
      ACCEPT_EULA: "Y"
    volumes:
      - sqldata:/var/opt/mssql
    healthcheck:
      test: /opt/mssql-tools/bin/sqlcmd -S sql-server -U sa -P "myPassw0rd" -Q "SELECT 1" -b -o /dev/null
      interval: 10s
      timeout: 3s
      retries: 10
      start_period: 10s
      
volumes:
  sqldata:
    name: sqldata

docker-sqlserver.md

docker run -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=myPassw0rd" -p 1434:1433 --name sql-server mcr.microsoft.com/mssql/server:2019-latest -d 

Sample connection_string: Data Source=sql-server;Initial Catalog=Tiered;User Id=sa;Password=myPassw0rd;MultipleActiveResultSets=true;Persist Security Info=True;