Create SQL Server SSL
I want to create a SQL Server SSL certificate on my Windows Server 2016, and I followed the steps shown in this Youtube video https://www.youtube.com/watch?v=m7ONeACYBdE&t=182s
In the video the presenter publish this PowerShell line:
New-SelfSignedCertificate -CertStoreLocation Cert:\LocalMachine\My -DnsName host.doman.com -KeySpec KeyExchange -FriendlyName SQLCer
Unfortunately the presenter didn't explain whether something should be changed in this line or whether it is generic, so when I use it on my PowerShell, it create the certificate but in the next step, when I need to select it in the Protocols Window (in the configuration Manager), the certificate in the "drop down" list is empty.
I used the PowerShell line exactly as I wrote it above, do I need change something in this line ? Is the certificate missing because of that or it's something else ?
According to your question of the part to be modified, you need to change the "DnsName" host.doman.com and replace it with your dns name
According to SQL Server SSL certificate please check the following URL for the steps