Launch Docker Image for MSSQL not creating a container

Question

I am trying to setup MSSQL for my macOS and can't get the docker image to load and create a container. I have downloaded Docker and have it up and running

Downloaded:

docker pull microsoft/mssql-server-linux

Then run via Terminal:

docker run -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=<my password here> -e 
'MSSQL_PID=Express' -p 1433:1433 -d microsoft/mssql-server- 
linux:latest

I then run

docker ps

and receive, with no data

CONTAINER ID        IMAGE               COMMAND             CREATED             STATUS              PORTS               NAMES

I am not sure where the issue occurring

Run docker ps -a then you will be able to see the stopped container and get the logs. — Jack Gore
– Jack Gore, Commented Jun 5, 2018 at 20:47
docker ps -a CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES nothing is returned — pdel5
– pdel5, Commented Jun 5, 2018 at 20:50

6be709c0 · Accepted Answer · 2018-06-05 21:58:56Z

3

Troubleshooting

run without -d command to launch the instance in attached mode.
docker ps -a give you the stopped containers
docker logs $stoppedContainerId give you the logs of a container

How to resolve

Well I tried by myself and I checked the logs >

2018-06-05 21:54:28.38 spid21s ERROR: Unable to set system administrator password: Password validation failed. The password does not meet SQL Server password policy requirements because it is too short. The password must be at least 8 characters..

I assume you have the same problem because it's working with a strong password.

answered Jun 5, 2018 at 21:58

6be709c0

8,5014 gold badges40 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Launch Docker Image for MSSQL not creating a container

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related