Need OnChange:Prevent SQL Password Policy enforcement RRS feed

  • Question

  • SQL Server 2008 Enterprise Edition SP1 (build 10.0.2723)

    I imported the delivered best practices SQL Server Password Policy with the intention to use it to enforce password policy for SQL accounts upon setup or change.  I was able to change the policy to go against just SQL Logins (changing the Against Target to a condition that evaluates facet Login @LoginType = SQLLogin.  I also changed the evaluation mode to OnChange:Prevent.

    Works great for SQL Logins, but unfortunately it also prevents any Windows authenticated logins from being added.

    Is this a known bug in the system or just a feature deficiency?
    Is there a way to get this policy to work on change:prevent but exclude it from checking Windows authenticated accounts?

    Monday, December 7, 2009 8:21 PM

All replies

  • *bump*
    Has anyone experienced this problem with Policy-Based Management?
    Wednesday, December 16, 2009 11:04 AM
  • *bump* again
    Has anyone attempted this and encountered this problem?
    Thursday, January 7, 2010 1:30 PM
  • I would use this to do this @PasswordPolicyEnforced = 'true'



    Tuesday, February 8, 2011 8:29 PM