1

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?

Tom
  • 295
  • 1
  • 11
  • 1
    Just out of curiosity, is there even a password policy? For instance can you set a password of a single character? – HBruijn Mar 08 '18 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 09 '18 at 11:32

0 Answers0