I've created a self-signed certificate and configured with SQL Server Express. The encryption works fine on my PC.
When I export the certificate to another PC I can import fine and can see the certificate in MMC under Personal > Certificates.
However when I try to configure with SQL Server Express on the new PC, the certificate does not appear in the dropdown.
Any suggestions?
I have tried a few things suggested on other forums
Making sure the private key is exported Making sure the certificate was created for local system (not user) Copy certificate into trusted certificates
The feedback I've got so far is that the certificate CN value is set to the computer name it was created on "Server1". This will not work when copying to another PC with a different computer name "Server2".
Is there a way around this?