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?
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?