I have configured Always Encrypted on a custom database using SQL Server 2016. By default, it creates the certificate with a validity of one year.
Is there any workaround to create this certificate for two or three years at the very beginning stage?
I don't want to rotate the key every year in our production environment rather create the certificate at least for two or three years.
Experts advise please.