Login failed for user 'sa' on Mac about mssql-docker HOT 12 CLOSED

Im using this password "reallyStrongPwd1239821Anbasjjh832Kaskhsd" and Im getting same issue

MacBook-Air-de-Joel:~ joelgarcia$ mssql -s localhost -u sa -p reallyStrongPwd1239821Anbasjjh832Kaskhsd Connecting to localhost... Error: Login failed for user 'sa'.

from mssql-docker.

@thearabbit '123456' may not be a sufficiently complex password. Please stop/remove your current container and try running a new container using a more complex password.

from mssql-docker.

@thearabbit Also, you shouldnt need to pass the -o parameter to the mssql command if you are using the default port, 1433.

from mssql-docker.

Look great, I work fine.
Very thank.

from mssql-docker.

Hi Guys ,
I am still having the issue please can someone help me on this .

vvvvvv-MBP:~ xxx$ mssql -s localhost -u sa -p PWSD@Test123
Connecting to localhost...
Error: Login failed for user 'sa'.
vvvvvv-MBP:~ xxx$

from mssql-docker.

Are you using -v in your docker run command?

from mssql-docker.

Thanks Guys.. @twright-msft pointed to the right , password issue.. @rameshrohan Test123 is not a complex password..

from mssql-docker.

@thearabbit Also, you shouldnt need to pass the -o parameter to the mssql command if you are using the default port, 1433.

Hi,
the docker connected well..it runs. but when i try to run the sql operations studio it gives me the 'Login failed for user ....' What am i doing wrong..been trying everything...nothing

from mssql-docker.

Ran the container using following command: docker run -d --name MSSQLLOCALCOMMUNITY -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=MyStrongPassword@123' -p 1433:1433 microsoft/mssql-server-linux

But when i try to connect to db it yields: Error: Login failed for user 'MSSQLLOCALCOMMUNITY'.

from mssql-docker.

still getting same error, after having tried multiple times.If anyone could identify whats wrong from my terminal below🥲

mac@Ghosts-MacBook-Pro ~ % docker images REPOSITORY TAG IMAGE ID CREATED SIZE mcr.microsoft.com/mssql/server 2019-latest 9ab26f8e5685 5 weeks ago 1.61GB mac@Ghosts-MacBook-Pro ~ % docker ps -a CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES mac@Ghosts-MacBook-Pro ~ % sudo npm install -g sql-cli Password: npm WARN config global --global, --localare deprecated. Use--location=global` instead.
npm WARN deprecated [email protected]: The sprintf package is deprecated in favor of sprintf-js.
npm WARN deprecated [email protected]: core-js@<3.23.3 is no longer maintained and not recommended for usage due to the number of issues. Because of the V8 engine whims, feature detection in old core-js versions could cause a slowdown up to 100x even if nothing is polyfilled. Some versions have web compatibility issues. Please, upgrade your dependencies to the actual version of core-js.

changed 48 packages, and audited 49 packages in 6s

1 package is looking for funding
run npm fund for details

found 0 vulnerabilities
mac@Ghosts-MacBook-Pro ~ % docker run --name GHOST -e 'ACCEPT_EULA=Y' -e 'SA_PASSWORD=1Unitedrange22’ -e 'MSSQL_PID=Developer’ -p 1433:1433 -d mcr.microsoft.com/mssql/server:2019-latest
5db465b250a8da5e47db009efa694dec025dd30cd0641fd5df84eb062774c424
mac@Ghosts-MacBook-Pro ~ % mssql -u sa -p 1Unitedrange2022
Connecting to localhost...
Error: Login failed for user 'sa'.`

from mssql-docker.

All the logic is in the password, that's why it doesn't log in, it lasted 3 days and I was never able to log in until the day I found these notes, which was the key. exactly was key. It must be very complex and long. mine was the following to be able to practice the change later @Pwd451EatonStrong

from mssql-docker.

that working very good @Pwd451EatonStrong

from mssql-docker.