1

We are trying to create HA Group using the always on feature .

Our database is encrypted with TDE using an EKM (External cryptographic provider- HSM) .

When trying to build availability group through the Wizard you can not choose databases with

encryption key , I have found one link which uses T-SQL script to bypass this issue , but it uses

the master key and not an external key (asymmetric)

https://www.simple-talk.com/sql/database-administration/encrypting-your-sql-server-2012-alwayson-availability-databases/

Is there a way to set it up with EKM?

Cœur
  • 37,241
  • 25
  • 195
  • 267
TheRunningDBA
  • 109
  • 1
  • 7
  • Google gives multiple definitions for EKM: "Extensible Key Management", "Encryption Key Manager", "Enterprise Key Management". Which one is it in your question? Because you seem to give it a fourth definition starting with "External ..." – Cœur Apr 09 '18 at 09:03

0 Answers0