Azure SQL Login Password Not Complex Enough Azure SQL Login Password Not Complex Enough sql-server sql-server

Azure SQL Login Password Not Complex Enough


From this articlehttps://msdn.microsoft.com/en-us/library/azure/jj943764.aspx you have to meet these requirements:

8 characters minimum and 16 characters maximum

Requires 3 out of 4 of the following:

Lowercase characters

Uppercase characters

Numbers (0-9)

Symbols (see password restrictions above)


Also, the password cannot contain the login-name in it.

i.e. if login-name is MyApiLogin then the password cannot be 20!8MyApiLogin2@18.

Even though it contains all the required as stated in the previous answers

Requires 3 out of 4 of the following:

Lowercase characters

Uppercase characters

Numbers (0-9)

Symbols


The 8-16 character limit is for Azure AD account passwords, not SQL login passwords. This article https://docs.microsoft.com/en-us/sql/relational-databases/security/strong-passwords gives the following recommendations for strong passwords

  • Is between 8 and 128 characters.
  • Combines letters, numbers, and symbol characters within the password.
  • If used in an OLE DB or ODBC connection string, a login or password must not contain the following characters: [] {}() , ; ? * ! @