Mssql-docker: Login failed for user 'SA' running microsoft/mssql-server-linux

Created on 3 Jun 2018  路  5Comments  路  Source: microsoft/mssql-docker

Hi when I try to connect to sql server container, I have the following error : Login failed for user 'SA'
untitled picture

docker version

Event if I run this sample : https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-docker?view=sql-server-linux-2017

All 5 comments

can you try changing the password to something like '12345qwerASDF'

thank @vin-yu
It works fine using password 12345qwerASDF
what is the password rules using linux container ?
Regards

  • The password does not contain the account name of the user.
  • The password is at least eight characters long.
  • The password contains characters from three of the following four categories:

    • Latin uppercase letters (A through Z)


    • Latin lowercase letters (a through z)


    • Base 10 digits (0 through 9)


    • Non-alphanumeric characters such as: exclamation point (!), dollar sign ($), number sign (#), or percent (%).

https://docs.microsoft.com/en-us/sql/relational-databases/security/password-policy?view=sql-server-2017

How do I turn this off though? If I'm installing this on a local machine for trialing, I don't want to have to use a "strong password". How can I disable the password policy requirements (before installing)?

@Grinderofl - Sorry there is not a way to disable the password policy check right now.

Was this page helpful?
0 / 5 - 0 ratings