CODEWITHSUNDEEP
sslencryptionssl-certificatesql-server-expressself-signed
McCann46
McCann46

Reputation: 77

Configuring Imported Self Signed SSL Certificate to SQL Server Express

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

Upvotes: 0

Views: 421

Answers (1)

John Hanley
John Hanley

Reputation: 81464

Look at the properties for the certificate CN value. You will find that it has the "computer name" of the system that you created it on (which means "localhost"). This will not work when you copy the certificate to another system as the machine name will be different.

Upvotes: 1

Related Questions