Good Morning Experts,
One of our SQL Server instance has few databases with encryption turned on. The backups for these databases were failing with below error:
Cannot open session for cryptographic provider 'LunaEKMProvider'. Provider error code: 5. (Authentication Failure - Consult EKM Provider for details)
However, when the server team rebooted this server on sunday as part of planned activity, the backup jobs ran successfully.
I just checked the encryption state and it is turned on. I am unable to understand why the backup jobs failed before the reboot?Please advise