Can Omni Password prevent access after a number of failed attempts?
Even though this feature has been requested a number of times, it is not technically possible from inside a SQL based application. To deny access after a number of failed attempts we need to be able to store the number of attempts and also store a setting to say whether access is now denied as well as read how many attempts are allowed. To store this information requires access to the SQL data so it can be written to a table, and that is precisely what we don’t have access to. As you can see this is a “Catch – 22” situation, only the SQL Server itself can implement this type of functionality. We believe that SQL Server 2005 will have this ability.