Consider the following scenario:
- You have a symmetric key that is encrypted by an asymmetric key in SQL Server 2017 on Windows.
- The asymmetric key is created by using an Extensible Key Management (EKM) provider.
- You try to open the encrypted symmetric key by using the following statement:
OPEN SYMMETRIC KEY KeyName DECRYPTION BY ASYMMETRIC KEY KeyName;
In this scenario, you receive an error message that resembles the following:
Msg 15466, Level 16, State 28, Line LineNumber
An error occurred during decryption.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.