3. SSL Certificate types and requirements for SQL Server

Let us learn types of SSL certificates which you can attach to SQL Server. Also, we quickly go through the certificate requirements which you should meet before attaching to SQL Server. Self-signed certificate generation command: 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 Key words: Encryption, SQL Server, SSL certificate, types, requirements ⏮️►Previous sessions: https://youtu.be/wbT1i-0pru8 https://youtu.be/nVcztBZGK-w ⏭️ ►Next session: https://youtu.be/JDzIRCTkRIU 📚 ►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