How to Create an SSL Certificate for SQL Server installations

This video shows how to create a certificate request file that will allow you to encrypt SQL Server network traffic using SSL encryption.

[andymoss]

I’ve made about 1000 certificates over the last 2 days and they just wouldn’t show up in the sql config manager > network config > protocols > properties > certificates drop down.

This has the secret sauce! I didn’t know I had to hit the make private key exportable. And see the key type to exchange.


Thank you! 🙏

[DIYProfit]

Thanks! Then how to push it to the right server to take effect?

[dansaeger]

What do  ido with the file once I have created it? I tried importing a certificate using the file, but it doesn't recognize the file extension (format).

[kirititadepalli]

I cant find certificates folder in the personal folder

[muthusundari]

There is no certificate folder in the personal folder