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: • 1. TLS Handshake in Windows.
• 2. Ways to encrypt connection to SQL ...
⏭️ ►Next session: • 4. Enable encryption in connections t...
📚 ►Full course on Encrypting connections to SQL Server- • Full course on Encrypting connections...
📷 ►Follow me on Instagram - https://www.instagram.com/arslanov_bo...
🧑💼►Follow me on LinkedIn - / bobirmirzo-arslanov-548960173
Watch all my playlists here:
🚀► Troubleshooting sessions: • Troubleshooting
🚀 ►SQL Server replication session: • SQL Server replication
🚀 ►SQL Server Always On Availability Group: • SQL Server Always On Availability Gro...
🚀 ► SQL Server internals: • SQL Internals
🚀 ► Course in On-memory OLTP: • Course on In-Memory OLTP