Generate Secret Key from Password

The GenEncodedSecretKey method provides a way to produce a secret key from an arbitrarily sized password string. The secret key produced will be equal in bit length to the KeyLength. A given string passed to GenEncodedSecretKey will always produce the same key. (In other words, this is really a hash function and not a random key generator.)

Download Chilkat Crypt ActiveX

CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    DECLARE @crypt int
    EXEC @hr = sp_OACreate 'Chilkat.Crypt2', @crypt OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    DECLARE @success int

    EXEC sp_OAMethod @crypt, 'UnlockComponent', @success OUT, 'Anything for 30-day Trial'
    IF @success <> 1
      BEGIN
        PRINT 'Crypt component unlock failed'
        RETURN
      END

    EXEC sp_OASetProperty @crypt, 'CryptAlgorithm', 'aes'
    EXEC sp_OASetProperty @crypt, 'KeyLength', 128

    --  Transform an arbitrary-length password to a secret key
    --  equal in bit-length to the KeyLength:
    DECLARE @hexKey nvarchar(4000)

    EXEC sp_OAMethod @crypt, 'GenEncodedSecretKey', @hexKey OUT, 'my_password', 'hex'

    --  Set the secret key:
    EXEC sp_OAMethod @crypt, 'SetEncodedKey', NULL, @hexKey, 'hex'

    --  The hexKey is 16 bytes in length:
    PRINT @hexKey
END
GO