Advertisement
Guest User

Untitled

a guest
Feb 7th, 2016
56
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.89 KB | None | 0 0
  1. $cert = New-SelfSignedCertificate `
  2. -Subject "Always Encrypted Sample Cert" `
  3. -CertStoreLocation Cert:CurrentUserMy `
  4. -Type Custom
  5. $thumbprint = $cert.ThumbPrint
  6. Write-Verbose "Cert thumbprint $thumbprint"
  7.  
  8. $smoDatabase.ExecuteNonQuery(@"
  9. CREATE COLUMN MASTER KEY [$($MasterKeyName)]
  10. WITH (
  11. KEY_STORE_PROVIDER_NAME = 'MSSQL_CERTIFICATE_STORE',
  12. KEY_PATH = N'CurrentUser/My/$($thumbprint)'
  13. );
  14. "@);
  15.  
  16. CREATE COLUMN ENCRYPTION KEY key_name
  17. WITH VALUES (
  18. COLUMN_MASTER_KEY = [$($MasterKeyName)],
  19. ALGORITHM = 'RSA_OAEP',
  20. ENCRYPTED_VALUE = $EncryptedValue
  21. );
  22.  
  23. C:Userszippy> $certProvider = new-object 'System.Data.SqlCLient.SqlColumnEncryptionCertificateStoreProvider'
  24. C:Userszippy> $byte = [byte[]]@() # I don't know what to put here
  25. C:Userszippy> $certProvider.EncryptColumnEncryptionKey('Current User/My/0879e6a82f7fe3f88e91e37e69f08c8fa1f4cc48', 'RSA_OAEP', $byte)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement