Error in Initialize(): 429

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:

  1. What can I do to work through this error so that I can use the sysresHashPwd function?
  2. Is this the function that iMIS uses when it hashes passwords?

Brad Cady

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

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