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
- create docker-compose file with the above
- try and run the manifest file
- will stop running with the above error