Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Login fails for SA sql server linux docker

I try to use sql server on docker, linux. I start the container like this:

docker run -d -p 1433:1433 -e sa_password="12345qwerASDF" -e ACCEPT_EULA=Y --name sql-server --hostname sql-server  microsoft/mssql-server-linux:2017-latest

When I try to connect, all I get is "Login failed for user 'sa'"

Tried with different password, with and without double and single quotes...

like image 811
Erik Lindstrom Avatar asked Dec 14 '22 15:12

Erik Lindstrom


1 Answers

Finally I got it to work:

docker run --name sqlserver --hostname sqlserver -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=1StrongPwd!!" -p 1433:1433 -d microsoft/mssql-server-linux:2017-latest 

I guess it should be MSSQL_SA_PASSWORD and not SA_PASSWORD

The documentation isn't clear in that part...

like image 146
Erik Lindstrom Avatar answered Dec 26 '22 06:12

Erik Lindstrom