SQL Server Docker container immediately exiting

Question

I am trying to run a SQL Server container on my mac through Docker.

I ran the following command:

docker run -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=strongpassword" -p 1433:1433 --name sqlservercontainer -d mcr.microsoft.com/mssql/server:2019-latest

But the container is immediately exiting.

The docker logs for the container look like this:

SQL Server 2019 will run as non-root by default.

This container is running as user mssql.

To learn more visit https://go.microsoft.com/fwlink/?linkid=2099216.

SQL Server 2019 will run as non-root by default.

This container is running as user mssql.

To learn more visit https://go.microsoft.com/fwlink/?linkid=2099216.

/opt/mssql/bin/sqlservr: Error: The system directory [/.system] could not be created. File: LinuxDirectory.cpp:420 [Status: 0xC0000022 Access Denied errno = 0xD(13) Permission denied]

/opt/mssql/bin/sqlservr: Error: The system directory [/.system] could not be created. File: LinuxDirectory.cpp:420 [Status: 0xC0000022 Access Denied errno = 0xD(13) Permission denied]

Any idea what needs to be done to solve this?

Answer 1

I found that this command works for me, here is why:

chown 10001:10001 <mount directory of /var/opt/mssql>

the uid and gid 10001 most likely won't be mapped to anything in yout host, but it will be mapped to mssql user inside the official container, here is one line of the passwd file from the image:

mssql:x:10001:10001::/home/mssql:/bin/bash