Blog Post

SQL Server Support Blog
2 MIN READ

SQL2019 certificate import error "selected certificate name does not match FQDN of this hostname"

YueJ_7's avatar
YueJ_7
Icon for Microsoft rankMicrosoft
Jul 29, 2020
Recently, I tried to use the SQL Server 2019 import certificate feature in configuration manager, however, when I import by the pfx file, it prompted me errors at the last step as below: Errors or ...
Published Jul 29, 2020
Version 1.0
SQL 2019
PatrickAndre-4710's avatar
PatrickAndre-4710
Copper Contributor
Feb 18, 2022

How could it be possible to have the certificate name the same as the computer name if you try to import the same certificate on the nodes of the cluster, using the import option of SQL Server Configuration Manager 2019 ? I use the AO listener FQDN as CN and in the alternative DNS, I type the name of the cluster nodes but still SQL Server Configuration Manager 2019 complaints with these errors:


Error:
The selected certificate name does not match FQDN of this hostname. This property is required by SQL Server
Error:
The selected certificate does not have the KeySpec Exchange property. This property is required by SQL Server to import a certificate.