N/APosted on - 02/23/2012
I am working on a procedure to validate Login attempts of our users since the current application we are using requires Active Directory to confirm the user Login and my machine is currently not in the AD server but in a different domain.
I am thinking of creating a CLR procedure on the SQL server found in the same domain. From the application implementation of a procedure from the SQL server which will call the procedure that will contain the CLR function.
It would then pass the user credentials of a particular user trying to Login and check if they are valid. I have already tried this procedure but I am having trouble with the installation of the CLR code.
I am now seeking for your intervention in this matter.
Procedure to validate Login attempts of users
Laurofarr hope the following steps will guide you in fixing of this issue.:
Actually the validation is done for the password is followed by the Password entered by the user will be compared in the formatted password present in database.
Here comes the issue about the Validation of the login attempts as the login attempt will be failed when the username and the password available in the database is not matched after submitting the data .
Invalid Login attempts are handled by the Membership Framework with the help of HTTP requests and by the Valid Username/Password pair.
Maximum Invalid Password Attempts " specifies how many times the invalid password is entered and submitted and this default value is set as 5.
Password Attempt Window " specifies the time period in minutes at the time of number of invalid attempts will result in the lock of the account and default value is 10.