teeravitdev/ms-sqlserver-2019 repository overview

⁠Microsoft SQL Server 2019 Docker Image

A lightweight, pre-configured Microsoft SQL Server 2019 container image designed for development, testing, and CI/CD environments.

⁠🚀 Quick Start

Run a standalone container instance using docker run:

docker run -d \
  --name mssql2019 \
  -p 1433:1433 \
  -e "ACCEPT_EULA=Y" \
  -e "MSSQL_SA_PASSWORD=YourStrong@Password123" \
  -v mssql_data:/var/opt/mssql \
  --restart unless-stopped \
  teeravitdev/ms-sqlserver-2019:2019-latest

⁠🐳 Docker Compose

For multi-container applications or local persistence, define your service in docker-compose.yml:

version: '3.8'

services:
  mssql:
    image: teeravitdev/ms-sqlserver-2019:2019-latest
    container_name: mssql2019
    restart: unless-stopped
    ports:
      - "1433:1433"
    environment:
      - ACCEPT_EULA=Y
      - MSSQL_SA_PASSWORD=YourStrong@Password123
    volumes:
      - mssql_data:/var/opt/mssql

volumes:
  mssql_data:

Start the container in the background:

docker compose up -d

⁠⚙️ Environment Variables

⁠🔌 Connection Details

Connect using database management tools like SSMS (SQL Server Management Studio), Azure Data Studio, or DBeaver:

• Server / Host: localhost,1433 (or 127.0.0.1,1433)
• Authentication: SQL Server Authentication
• User Name: sa
• Password: <MSSQL_SA_PASSWORD>

⁠🔒 Security Best Practices

• Password Policy: Ensure MSSQL_SA_PASSWORD contains at least 8 characters with upper/lowercase letters, digits, and special symbols.
• Data Persistence: Always mount a volume to /var/opt/mssql so your databases and log files persist across container restarts or removals.
• Port Security: Do not expose port 1433 directly to public networks in production environments without firewall or VPN protection.