Listing 3: Enabling the EKM Provider to Store Login Credentials

CREATE CREDENTIAL EKMCredential
WITH IDENTITY='EKMForLogin1'
, SECRET='MustHaveAStrongPassPhraseHere'
  FOR CRYPTOGRAPHIC_PROVIDER XXXX
-- Must provide name of existing provider
GO

/* Alter the login to use credential */
ALTER LOGIN Login1
ADD CREDENTIAL EKMForLogin1
GO