We are implementing TDE in MS SQL SEREVR 2019 with EKM provider. We are using asymmetric key to encrypt the data at rest. Asymmetric key will be hosted in HSM appliances.
I have one questions regarding that.
What will be the effect if our SQL Server isn't able to connect with HSM appliances?
Will the application be able to do the normal DML process on encrypted database, as database is encrypted and it’s not able to connect with HSM appliance?