CODEWITHSUNDEEP
sql-serverlinuxmacosdocker
Benoit Desrosiers
Benoit Desrosiers

Reputation: 183

cannot connect on SQLserver with Docker on mac

I'm trying to setup SQLserver on my mac using Docker. When I start it, it seems to be working, but when I try to connect with mssql, it crashes. I have tried with localhost instead of 0.0.0.0, same result. 

iMac benoitd$ **docker run** -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=DB22017' -p 
1433:1433 -d microsoft/mssql-server-linux

ee2f1a94410dfb6e5f39ba009ffee20b906270e9602d831ff2344e93d2ec5d14

iMac benoitd$ **docker ps**

CONTAINER ID        IMAGE                          COMMAND                  CREATED             STATUS              PORTS                    NAMES
ee2f1a94410d        microsoft/mssql-server-linux   "/bin/sh -c /opt/mssq"   4 seconds ago       Up 2 seconds        0.0.0.0:1433->1433/tcp   awesome_mahavira

iMac benoitd$ **mssql -s 0.0.0.0:1433 -u sa -p 'DB22017'**

Connecting to 0.0.0.0:1433...
Error: Failed to connect to 0.0.0.0:1433:1433 - getaddrinfo ENOTFOUND 0.0.0.0:1433 0.0.0.0:1433:1433

iMac benoitd$ **docker ps**

CONTAINER ID        IMAGE               COMMAND             CREATED             STATUS              PORTS               NAMES

Upvotes: 2

Views: 1231

Answers (1)

Benoit Desrosiers
Benoit Desrosiers

Reputation: 183

d'oh.... the problem was with the password for sql server. It need to be a strong pw.

thanks for your help! and happy new year :)

Upvotes: 4

Related Questions