FIX: Error occurs when you open a symmetric key that is encrypted by an asymmetric key in SQL Server 2017

Applies to: SQL Server 2017 Developer on WindowsSQL Server 2017 Enterprise on WindowsSQL Server 2017 Enterprise Core on Windows

Symptoms


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:

In this scenario, you receive an error message that resembles the following: 

Resolution


This issue is fixed in the following cumulative update for SQL Server:

       Cumulative Update 10 for SQL Server 2017

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References


Learn about the terminology that Microsoft uses to describe software updates.