Corrrection - its optional now. From web.config
passwordAttemptThreshold="int" The number of failed password attempts, or failed password answer attempts that are allowed before locking out a user?s account (where "int" equals the desired number).
To enable this just look for this in web.config and add the setting to the DNNSQLMembershipProvider options.