2

From what I can make out from Google, SQL Server on Windows uses the system password complexity policy.

I'm creating users on an SQL Server for Linux instance which is not tied to a domain, using CREATE LOGIN [...] WITH PASSWORD.... Where is the password complexity policy set for this type of user and how can I change it?

2
  • 1
    Just out of curiosity, is there even a password policy? For instance can you set a password of a single character?
    – HBruijn
    Mar 8, 2018 at 11:59
  • I have SQL server running on Ubuntu 16.04. When I create a login with a password and the must change on first use option and the user tries to login from Windows, a password complexity policy is applied (at least 8 characters, mix of upper, lower and symbols). I suppose it might be applying the client's Windows complexity policy?
    – Tom
    Mar 9, 2018 at 11:32

1 Answer 1

1

https://learn.microsoft.com/en-us/sql/linux/sql-server-linux-security-overview?view=sql-server-ver16

SQL Server on Linux currently has the following limitations:

  • A standard password policy is provided. MUST_CHANGE is the only option you may configure. CHECK_POLICY option is not supported.

Standard Complexity is: https://learn.microsoft.com/en-us/sql/relational-databases/security/password-policy?view=sql-server-ver16#password-complexity

Standard (hard coded) expiration 90 days see this: https://github.com/MicrosoftDocs/sql-docs/issues/9147 and https://learn.microsoft.com/en-us/answers/questions/1079552/mssql-2019-on-linux-login-expiry-default)

1
  • Haha this is so long ago I can't even remember what project I was using MSSQL on. Thanks though.
    – Tom
    Jul 12, 2023 at 8:40

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .