How to attach SSL/TLS certificate to SQL Server?

In this video, I will show you how to attach SSL certificate to standalone SQL Server instance. SQL server certificate requirements: https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/certificate-requirements?view=sql-server-ver16 Command to generate self-signed certificate for SQL Server: ======================================== New-SelfSignedCertificate -KeyExportPolicy Exportable -Subject "CN=AG2019-SQLVM-1.mydom.com" -NotBefore (Get-Date) -NotAfter (Get-Date).AddMonths(6) -TextExtension @("2.5.29.37={text}1.3.6.1.5.5.7.3.1") -CertStoreLocation "cert:\LocalMachine\My" -KeySpec KeyExchange -Provider "Microsoft RSA SChannel Cryptographic Provider" -KeyUsage CertSign -HashAlgorithm sha256 ======================================== *** Please change CN to the full computer name. In my case, it is "WS20162.corp.contoso.com". *** Please change 6 to the number of months accordingly until which you want the certificate to be valid. ⏭️ ►Next session: https://youtu.be/nVcztBZGK-w 📚 ►Full course on Encrypting connections to SQL Server- https://youtube.com/playlist?list=PLxuuX6jGq7kmqOCqYa1lFxQOKFgTfb8j8&si=bBwHhLsu6m5CjFft 📷 ►Follow me on Instagram - https://www.instagram.com/arslanov_boburmirzo?igsh=OGQ5ZDc2ODk2ZA%3D%3D&utm_source=qr 🧑‍💼►Follow me on LinkedIn - https://www.linkedin.com/in/bobirmirzo-arslanov-548960173 Watch all my playlists here: 🚀► Troubleshooting sessions: https://youtube.com/playlist?list=PLxuuX6jGq7kmlUblaWyfIh-iT5r0EWrJX&si=gC5FAhH9i6_b0waY 🚀 ►SQL Server replication session: https://youtube.com/playlist?list=PLxuuX6jGq7km5E54qm0zc7REGXw6WD4C8&si=fQ_PVoGQ1S8SeI6X 🚀 ►SQL Server Always On Availability Group: https://youtube.com/playlist?list=PLxuuX6jGq7klnjr9OIGt8R1SN76pQzuEB&si=zZVr_sJnc7I9H8d3 🚀 ► SQL Server internals: https://youtube.com/playlist?list=PLxuuX6jGq7kk5_OkxbZ8QDZ2HFBDy2XZ2&si=U2rRfgS2y87t5SU4 🚀 ► Course in On-memory OLTP: https://youtube.com/playlist?list=PLxuuX6jGq7kmt6gfHUW5KhfXGaoSiDXOB&si=fVS1s2L6If36Zg-r