I'm trying to use the sysresHashPwd function to return a value in SQL thinking that this may be the function that is hashing the Password field in Name_Security. When I use the following:
SELECT dbo.sysresHashPwd ('password')
I receive the following message:
Error in Initialize(): 429
So there are 2 questions:
- What can I do to work through this error so that I can use the sysresHashPwd function?
- Is this the function that iMIS uses when it hashes passwords?
Brad Cady
For the second question...
iMIS doesn't use this function. See these threads for more details; you might look at SQL CLR.
http://www.imiscommunity.com/web_cc_encryption_and_password_hashing
http://www.imiscommunity.com/decrypting_data