RSA Encrypt/Decrypt AES Key

Demonstrates how to use RSA to protect a key for AES encryption. It can be used in this scenario: You will provide your RSA public key to any number of counterparts. Your counterpart will generate an AES key, encrypt data (or a file) using it, then encrypt the AES key using your RSA public key. Your counterpart sends you both the encrypted data and the encrypted key. Since you are the only one with access to the RSA private key, only you can decrypt the AES key. You decrypt the key, then decrypt the data using the AES key.

This example will show the entire process. (1) Generate an RSA key and save both private and public parts to PEM files. (2) Encrypt a file using a randomly generated AES encryption key. (3) RSA encrypt the AES key. (4) RSA decrypt the AES key. (5) Use it to AES decrypt the file or data.

Download 32-bit Chilkat RSA ActiveX (.msi)

Download All 32-bit Chilkat ActiveX Components (.zip)

Download All 64-bit Chilkat ActiveX Components (.zip)

Download Chilkat Crypt ActiveX

CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    DECLARE @sTmp0 nvarchar(4000)
    -- 
    --   This example requires two Chilkat licenses:  RSA and Crypt.
    -- 

    --  ------------------
    --  Step 1.  Generate an RSA key and save to PEM files.

    DECLARE @rsa int
    EXEC @hr = sp_OACreate 'Chilkat.Rsa', @rsa OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    DECLARE @success int

    EXEC sp_OAMethod @rsa, 'UnlockComponent', @success OUT, 'Anything for 30-day trial'
    IF @success <> 1
      BEGIN
        EXEC sp_OAGetProperty @rsa, 'LastErrorText', @sTmp0 OUT

        PRINT @sTmp0
        RETURN
      END

    --  Generate a 1024-bit key.  Chilkat RSA supports
    --  key sizes ranging from 512 bits to 4096 bits.
    EXEC sp_OAMethod @rsa, 'GenerateKey', @success OUT, 1024
    IF @success <> 1
      BEGIN
        EXEC sp_OAGetProperty @rsa, 'LastErrorText', @sTmp0 OUT

        PRINT @sTmp0
        RETURN
      END

    --  Keys are exported in XML format:
    DECLARE @pubKeyXml nvarchar(4000)

    EXEC sp_OAMethod @rsa, 'ExportPublicKey', @pubKeyXml OUT

    DECLARE @pubKey int
    EXEC @hr = sp_OACreate 'Chilkat.PublicKey', @pubKey OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    EXEC sp_OAMethod @pubKey, 'LoadXml', @success OUT, @pubKeyXml
    --  For brevity, we are not checking the return value...
    EXEC sp_OAMethod @pubKey, 'SaveOpenSslPemFile', @success OUT, 'pubKey.pem'

    DECLARE @privKeyXml nvarchar(4000)

    EXEC sp_OAMethod @rsa, 'ExportPrivateKey', @privKeyXml OUT

    DECLARE @privKey int
    EXEC @hr = sp_OACreate 'Chilkat.PrivateKey', @privKey OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    EXEC sp_OAMethod @privKey, 'LoadXml', @success OUT, @privKeyXml
    EXEC sp_OAMethod @privKey, 'SaveRsaPemFile', @success OUT, 'privKey.pem'

    --  Other methods exist for saving the private key in PKCS8 format,
    --  both encrypted and un-encrypted..

    --  ------------------
    --  Step 2.   This is the code your counterpart will run to
    --  AES encrypt a file.  It generates a random AES key
    --  to use for the encryption.

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

    EXEC sp_OAMethod @crypt, 'UnlockComponent', @success OUT, 'Anything for 30-day trial'
    IF @success <> 1
      BEGIN
        EXEC sp_OAGetProperty @crypt, 'LastErrorText', @sTmp0 OUT

        PRINT @sTmp0
        RETURN
      END

    EXEC sp_OASetProperty @crypt, 'CryptAlgorithm', 'aes'
    EXEC sp_OASetProperty @crypt, 'CipherMode', 'cbc'
    EXEC sp_OASetProperty @crypt, 'KeyLength', 256

    --  Generate random bytes and return the random bytes
    --  in a hex string:
    EXEC sp_OASetProperty @crypt, 'EncodingMode', 'hex'
    DECLARE @randomKey nvarchar(4000)

    EXEC sp_OAMethod @crypt, 'GenRandomBytesENC', @randomKey OUT, 32

    --  Set the key.
    EXEC sp_OAMethod @crypt, 'SetEncodedKey', NULL, @randomKey, 'hex'

    --  Set the IV to a known value that will be used on both sides.
    --  (If desired, you could generate a random IV and protect it in the same
    --  way as the key...)
    --  The length of the IV for AES is always 16 bytes, regardless of the key size.
    EXEC sp_OAMethod @crypt, 'SetEncodedIV', NULL, '000102030405060708090A0B0C0D0E0F', 'hex'

    --  AES Encrypt the file (the file may be any size because it will
    --  stream the file in/out.
    EXEC sp_OAMethod @crypt, 'CkEncryptFile', @success OUT, 'hamlet.xml', 'aesEncrypted.dat'
    IF @success <> 1
      BEGIN
        EXEC sp_OAGetProperty @crypt, 'LastErrorText', @sTmp0 OUT

        PRINT @sTmp0
        RETURN
      END

    --  ------------------
    --  Step 3.
    --  ------------------
    --  RSA encrypt the AES key.
    --  We'll pretend  your counter part has the public-key PEM file and needs
    --  to load it.  Therefore, we'll start with a new RSA object and load
    --  the public key from the PEM..
    DECLARE @rsa2 int
    EXEC @hr = sp_OACreate 'Chilkat.Rsa', @rsa2 OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    DECLARE @pubKey2 int
    EXEC @hr = sp_OACreate 'Chilkat.PublicKey', @pubKey2 OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    --  For brevity, don't check the success..
    EXEC sp_OAMethod @pubKey2, 'LoadOpenSslPemFile', @success OUT, 'pubKey.pem'
    EXEC sp_OAMethod @pubKey2, 'GetXml', @pubKeyXml OUT
    EXEC sp_OAMethod @rsa2, 'ImportPublicKey', @success OUT, @pubKeyXml

    --  RSA encrypt the AES key and return it as a base64 encoded string.
    EXEC sp_OASetProperty @rsa2, 'EncodingMode', 'base64'
    DECLARE @bUsePrivateKey int

    SELECT @bUsePrivateKey = 0
    DECLARE @encryptedAesKey nvarchar(4000)

    EXEC sp_OAMethod @rsa2, 'EncryptStringENC', @encryptedAesKey OUT, @randomKey, @bUsePrivateKey

    --  At this point, your counterpart sends you the encryptedAesKey,
    --  and the encrypted file.

    --  ------------------
    --  Step 4 - RSA decrypt the AES key.
    --  ------------------

    --  Start with a new RSA object and load the private key from the PEM.
    DECLARE @rsa3 int
    EXEC @hr = sp_OACreate 'Chilkat.Rsa', @rsa3 OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    DECLARE @privKey2 int
    EXEC @hr = sp_OACreate 'Chilkat.PrivateKey', @privKey2 OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    EXEC sp_OAMethod @privKey2, 'LoadPemFile', @success OUT, 'privKey.pem'
    EXEC sp_OAMethod @privKey2, 'GetXml', @privKeyXml OUT
    EXEC sp_OAMethod @rsa3, 'ImportPrivateKey', @success OUT, @privKeyXml

    --  The encrypted AES key is encoded using base64, so set
    --  our EncodingMode to "base64".
    EXEC sp_OASetProperty @rsa3, 'EncodingMode', 'base64'

    SELECT @bUsePrivateKey = 1
    DECLARE @decryptedAesKey nvarchar(4000)

    EXEC sp_OAMethod @rsa3, 'DecryptStringENC', @decryptedAesKey OUT, @encryptedAesKey, @bUsePrivateKey

    --  ------------------
    --  Step 5 - AES decrypt the file.
    --  ------------------

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

    EXEC sp_OASetProperty @crypt2, 'CryptAlgorithm', 'aes'
    EXEC sp_OASetProperty @crypt2, 'CipherMode', 'cbc'
    EXEC sp_OASetProperty @crypt2, 'KeyLength', 256

    --  Set the key.
    EXEC sp_OAMethod @crypt2, 'SetEncodedKey', NULL, @decryptedAesKey, 'hex'

    --  Set the IV
    EXEC sp_OAMethod @crypt2, 'SetEncodedIV', NULL, '000102030405060708090A0B0C0D0E0F', 'hex'

    --  AES Decrypt the file (the file may be any size because it will
    --  stream the file in/out.
    EXEC sp_OAMethod @crypt2, 'CkDecryptFile', @success OUT, 'aesEncrypted.dat', 'decrypted.xml'
    IF @success <> 1
      BEGIN
        EXEC sp_OAGetProperty @crypt2, 'LastErrorText', @sTmp0 OUT

        PRINT @sTmp0
        RETURN
      END

END
GO