Docker Community Forums

Share and learn in the Docker community.

LCOW stopping mssql container instantly

Expected behavior

Start the MSSQL server container and keep it running

Actual behavior

Container starts and shuts down

Information

I’m using docker-compose, I’m not sure how to set the memory limits within docker-compose.yml file, I get the following error:

This container is running as user root.
To learn more visit https://go.microsoft.com/fwlink/?linkid=2099216.
sqlservr: This program requires a machine with at least 2000 megabytes of memory.
/opt/mssql/bin/sqlservr: This program requires a machine with at least 2000 megabytes of memory.

This is what I’m using in the docker-compose file:

production-sql:
image: mcr.microsoft.com/mssql/server
ports:
- “1437:1433”
environment:
- “SA_PASSWORD=Password”
- “ACCEPT_EULA=Y”
- “MSSQL_PID=Standard”
volumes:
- ‘D:\Work\docker\prod-build\prod-resources\neutrino-sql-dbs:/mnt/dbs’
- ‘D:\Work\docker\prod-build\prod-resources\neutrino-sql-bak:/mnt/baks’

Currently running:

Docker version 19.03.5, build 2ee0c57608
docker-compose version 1.25.1, build a82fef07

Steps to reproduce the behavior

  1. create docker-compose file with the above
  2. try and run the manifest file
  3. will stop running with the above error