Sample code for 30+ languages & platforms
SQL Server Requires Chilkat v11.0.0+

Sign and encrypt an email with S/MIME

See more Email Object Examples

Use the sender’s signing PFX and the recipient’s public RSA certificate with with-attachments.eml, which has one recipient. Supply your own signing-key password from a credential store. Render to bytes to apply both S/MIME operations without connecting to SMTP.

Chilkat SQL Server Downloads

SQL Server
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    DECLARE @sTmp0 nvarchar(4000)
    DECLARE @success int
    SELECT @success = 0

    --  Assumes Chilkat is unlocked. See Global Unlock Sample.

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

    EXEC sp_OAMethod @email, 'LoadEml', @success OUT, 'with-attachments.eml'
    IF @success <> 1
      BEGIN
        EXEC sp_OAGetProperty @email, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @email
        RETURN
      END
    DECLARE @signer int
    EXEC @hr = sp_OACreate 'Chilkat.Cert', @signer OUT

    EXEC sp_OAMethod @signer, 'LoadPfxFile', @success OUT, 'signer.pfx', 'SIGNER_PASSWORD'
    IF @success <> 1
      BEGIN
        EXEC sp_OAGetProperty @signer, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @email
        EXEC @hr = sp_OADestroy @signer
        RETURN
      END
    DECLARE @recipient int
    EXEC @hr = sp_OACreate 'Chilkat.Cert', @recipient OUT

    EXEC sp_OAMethod @recipient, 'LoadFromFile', @success OUT, 'recipient.cer'
    IF @success <> 1
      BEGIN
        EXEC sp_OAGetProperty @recipient, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @email
        EXEC @hr = sp_OADestroy @signer
        EXEC @hr = sp_OADestroy @recipient
        RETURN
      END
    EXEC sp_OAMethod @email, 'SetSigningCert', @success OUT, @signer
    IF @success <> 1
      BEGIN
        EXEC sp_OAGetProperty @email, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @email
        EXEC @hr = sp_OADestroy @signer
        EXEC @hr = sp_OADestroy @recipient
        RETURN
      END
    EXEC sp_OAMethod @email, 'SetEncryptCert', @success OUT, @recipient
    IF @success <> 1
      BEGIN
        EXEC sp_OAGetProperty @email, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @email
        EXEC @hr = sp_OADestroy @signer
        EXEC @hr = sp_OADestroy @recipient
        RETURN
      END
    EXEC sp_OASetProperty @email, 'SigningHashAlg', 'sha256'
    EXEC sp_OASetProperty @email, 'Pkcs7CryptAlg', 'aes'
    EXEC sp_OASetProperty @email, 'Pkcs7KeyLength', 256
    EXEC sp_OASetProperty @email, 'OaepPadding', 1
    EXEC sp_OASetProperty @email, 'OaepHash', 'sha256'
    EXEC sp_OASetProperty @email, 'OaepMgfHash', 'sha256'
    EXEC sp_OASetProperty @email, 'SendSigned', 1
    EXEC sp_OASetProperty @email, 'SendEncrypted', 1
    DECLARE @mail int
    EXEC @hr = sp_OACreate 'Chilkat.MailMan', @mail OUT

    DECLARE @rendered int
    EXEC @hr = sp_OACreate 'Chilkat.BinData', @rendered OUT

    EXEC sp_OAMethod @mail, 'RenderToMimeBd', @success OUT, @email, @rendered
    IF @success <> 1
      BEGIN
        EXEC sp_OAGetProperty @mail, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @email
        EXEC @hr = sp_OADestroy @signer
        EXEC @hr = sp_OADestroy @recipient
        EXEC @hr = sp_OADestroy @mail
        EXEC @hr = sp_OADestroy @rendered
        RETURN
      END
    EXEC sp_OAMethod @rendered, 'WriteFile', @success OUT, 'signed-encrypted.eml'
    IF @success <> 1
      BEGIN

        PRINT 'Failed: rendered.WriteFile.'
        EXEC @hr = sp_OADestroy @email
        EXEC @hr = sp_OADestroy @signer
        EXEC @hr = sp_OADestroy @recipient
        EXEC @hr = sp_OADestroy @mail
        EXEC @hr = sp_OADestroy @rendered
        RETURN
      END

    PRINT 'Saved signed-encrypted.eml.'

    EXEC @hr = sp_OADestroy @email
    EXEC @hr = sp_OADestroy @signer
    EXEC @hr = sp_OADestroy @recipient
    EXEC @hr = sp_OADestroy @mail
    EXEC @hr = sp_OADestroy @rendered


END
GO