Sign inSign up

usildevops/mssql-docker-enhanced

By usildevops

•Updated over 3 years ago

An enhancement of mcr.microsoft.com/mssql/server

Image
0

2.4K

usildevops/mssql-docker-enhanced repository overview

⁠MS SQL Server - Enhanced

A minimal enhancement of the official mcr.microsoft.com/mssql/server⁠ image provided by https://github.com/microsoft/mssql-docker⁠ which has some missed features.

⁠Github Repository

⁠Notes

⁠Tags

tagoperative systemsql server versionEdition
ubuntu-20.04.6_2022-RTM-CU3_dev-editionLinux (Ubuntu 20.04.6 LTS)Microsoft SQL Server 2022 (RTM-CU3) (KB5024396) - 16.0.4025.1 (X64)Developer Edition (64-bit)

⁠Environment Variables

namesample valuedescription
ACCEPT_EULA1Confirms the acceptance of End-User Licensing Agreement.⁠
MSSQL_PIDDeveloperIs the Product ID (PID) or Edition that the container will run with
MSSQL_USERsaDefault sa user
MSSQL_SA_PASSWORD****Is the database system administrator (userid = 'sa')
TZAmerica/LimaYour preffered timezone

More details here: https://hub.docker.com/_/microsoft-mssql-server⁠

⁠Download

docker push usildevops/mssql-docker-enhanced:latest

⁠Local build

docker build -t mssql-docker-enhanced .

⁠docker-compose

version: '3.7'

services:
 mssql-docker-enhanced:
    image: usildevops/mssql-docker-enhanced
    container_name: mssql-docker-enhanced
    shm_size: 1g
    ports:
     - "1433:1433"
    environment:
      ACCEPT_EULA: 1
      MSSQL_PID: Developer
      MSSQL_USER: sa
      MSSQL_SA_PASSWORD: 70quasWNl*o#nu4U
      TZ: America/Lima
    volumes:
      - ./my/scripts:/docker-entrypoint-initdb.d
    healthcheck:
      test: cat /var/log/docker/sqlserver_db_init.log | grep [db_init_completed]
      interval: 10s
      timeout: 3s
      retries: 10
      start_period: 10s 

Set your own password

And use these parameters to connect from your favourite ide:

image

⁠Features

  • Execute sql scripts at the database start ./my/scripts:/docker-entrypoint-initdb.d

⁠Acknowledgments

⁠Contributors

Tag summary

Content type

Image

Digest

sha256:8abd0bbf3…

Size

525.4 MB

Last updated

over 3 years ago

docker pull usildevops/mssql-docker-enhanced