@Murali (3/6/2014)
HiI would like to enforce password policy for non-AD accounts.
when I select enfocre password policy on SQL server it will enforce default policy (minimum 8 char with alphanumeric).
As per the new security policy, I need to enforce it to minimum 16 char for non-AD accounts. Is there any way that we can create new policy on SQL server Policy Management.?
Thanks,
Murali
Enabling the "enforce password policy" for a SQL account does indeed pick up from the local OS policy. If the server is not on a domain the local policy will apply. For Active Directory joined servers, the password policy is set at the lowest point at domain level, which propogates to machine level. Changing the domain policy means changing for all users in the domain, something which you may or may not want to do. Speak to your domain admins
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉