I am accessing SQL Server using a Docker container, and have done using this step:
docker run -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=Password@123" -e "MSSQL_PID=Express" -p 1433:1433 -v mssqlserver_volume:/var/opt/mssql --name mssql -d mcr.microsoft.com/mssql/server:2019-CU15-ubuntu-20.04
(I use this code in cmd to create a container)Continue command docker ps
The container able to created but the status only showed running for 1 seconds, then keep exited. The logs keeps shows this when I try to run the container:
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.
Now I not able to proceed with command this code
docker exec -it mssql /opt/mssql-tools/bin/sqlcmd -S localhost -U sa -P Password@123
since the container keeps showing "exited".
The methods have I tried is to restart and also swapping memory from wsl1 to wsl2 but it didn't solve my problem
Kindly need assistance to solve this problem.