Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 sha 256 issue

Author  Topic 

pnpsql
Posting Yak Master

246 Posts

Posted - 2012-05-12 : 06:40:35
hi team , i am working on password manage ment project,
there is a login page on my application, where the user enters the user name and password
tthe password get encrypted in sha 256 hash and match the value of hash with already saved hash password for that user.
when both hashes are matched then user is allowed for login. there is a password change page where user can change its password and the new password hash is saved in table.
the same code is called for bot hashing and this is written in java.

now there is some module enhancement where we need that when user does not login for 3 dayus then its account is locked and
need to reset by admin. the problem arises here i write a clr code that converts a string to
sha 256 hash and call it in proc, after reset the passoword when user tries to enter in application
it returns error that invalid password , becasue there are some mismacth in java hashing that is applies on front end of application and the clr hashing .


please suggets the best way that i can use.


challenge everything

challenge everything
   

- Advertisement -