Re: SQL Server 2005 password policy

I think you will find that you can't change the password policy in Windows
XP and have it affect your SQL passwords. On other versions of Windows, SQL
Server 2005 implements a default password complexity policy so this is
probably what you are seeing. Books Online has a description of the default
password policy

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

"Ron Lytal" <ron.lytal@xxxxxxxxxxxx> wrote in message
news:%23ndZ3qQVGHA.4792@xxxxxxxxxxxxxxxxxxxxxxx
I'm using SQL Server 2005 on both XP-SP2 and Server 2003 boxes. The docs
I have read state that the Password complexity / expiration features are
enabled only on Server 2003 and above. However, these features appear
functional on the SQL 2005 installs on the XP-SP2 boxes.. The docs say
the NetValidatePasswordPolicy() API is used, and that it is only available
in Windows Server 2003 and above! Anyone know why it is functioning on
the XP boxes? Bad docs?






.

Relevant Pages

  • Password policy
    ... I am using windows 2000 server, running 10 workstations, recently within the ... password policy complexity something. ...
    (microsoft.public.win2000.advanced_server)
  • Re: Linux kerberos authentication ; gdm
    ... I must tell that there is no windows server in that network neither any ... I want to authenticate some linux computers on a kerberos ... changed (and where must I configure that password policy? ...
    (comp.protocols.kerberos)
  • Password Policy and Screen Saver Settings via GPO
    ... I created a password policy for my organisation at the domain level via ... I am running in a Windows 2000 server ... environment SP4. ...
    (microsoft.public.windows.group_policy)
  • Re: Password policy
    ... Password policies must be set at the domain level. ... Windows 2003 as well. ... > the password policy, and link it to domain controllers. ... > replicate to all domain computers. ...
    (microsoft.public.win2000.security)
  • Re: 2003 AD Security policy question
    ... > That has not changed for Windows 2003. ... > password policy for a group domain users, ... > into smart cards for that group of users and configure their user accounts ... >> up a stronger password policy for certain groups. ...
    (microsoft.public.win2000.security)