Listing 1: Enabling EKM and Creating EKM Providers

-- Verify the status of EKM
SELECT * FROM sys.configurations
WHERE name = 'EKM provider enabled'

-- BEGIN CALLOUT A
--You must first enable the server for EKM
-- if not enabled
EXEC sp_configure 'EKM provider enabled', 1
RECONFIGURE
-- END CALLOUT A

-- Verify the status of EKM
SELECT * FROM sys.configurations
WHERE name = 'EKM provider enabled'

-- BEGIN CALLOUT B
-- Install the provider for EKM
CREATE CRYPTOGRAPHIC PROVIDER EKM_Provider_Module
FROM FILE = '<location of the provider dll file>'
-- END CALLOUT B