SQL Server
SQL Server
Save a Private Key as an Encrypted PKCS #8 DER File
See more Private Key Examples
Demonstrates the Chilkat PrivateKey.SavePkcs8EncryptedFile method, which saves the key as password-protected PKCS #8 DER. The first argument is the password and the second is the destination path. The cipher is selected by Pkcs8EncryptAlg.
Note: The file paths are relative to the application's current working directory. Absolute paths may also be used. Supply the paths appropriate to your own environment.
Background: This is the recommended way to persist a key to disk: the binary
.der is encrypted under a passphrase, so a stolen file is useless without it. Reach for it whenever a key is stored or shipped. Choose the encryption cipher with Pkcs8EncryptAlg and source the password securely.Chilkat SQL Server Downloads
-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
DECLARE @hr int
DECLARE @sTmp0 nvarchar(4000)
DECLARE @success int
SELECT @success = 0
-- Load a private key to export.
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, 'LoadPemFile', @success OUT, 'qa_data/private.pem'
IF @success = 0
BEGIN
EXEC sp_OAGetProperty @privKey, 'LastErrorText', @sTmp0 OUT
PRINT @sTmp0
EXEC @hr = sp_OADestroy @privKey
RETURN
END
-- The key password is not hard-coded in a real application; obtain it from an interactive
-- prompt, environment variable, or a secrets vault.
DECLARE @password nvarchar(4000)
SELECT @password = 'myKeyPassword'
-- Save as password-protected PKCS #8 DER. The 1st argument is the password and the 2nd is the
-- destination path. The cipher is selected by the Pkcs8EncryptAlg property.
EXEC sp_OAMethod @privKey, 'SavePkcs8EncryptedFile', @success OUT, @password, 'qa_output/private_pkcs8_enc.der'
IF @success = 0
BEGIN
EXEC sp_OAGetProperty @privKey, 'LastErrorText', @sTmp0 OUT
PRINT @sTmp0
EXEC @hr = sp_OADestroy @privKey
RETURN
END
PRINT 'Saved (encrypted).'
EXEC @hr = sp_OADestroy @privKey
END
GO