TLS | SSL |
Transparent Layer Security (TLS) | Secure Sockets Layer (SSL) |
versions: SSL (1.0, 2.0, 3.0) | versions:TLS (1.0,1.1,1.2,1.3) |
Vulnerabilities discovered in all versions | Vulnerabilities in 1.0& 1.1 |
Founder: Internet Egineering Taskforce 1999 | Founder: Taher Elgamal (Netscape) 1995 |
-TLS 1.0 & 1.1 now deprecated
-SSL 2.0 & SSL 3.0 were deprecated in 2011 & 2015. Vulnerabilites continue to be discovered - Heartbleed , POODLE
-Certificates are not dependant on protocols
-The certificate facilitates the handshake between the server & client. At the handshake phase - the protocol version is established , as well as the shared secret & that is the key determinant in the encryption strength.
Read more on SSL,TLS & SQL Server
How to generate a self signed certificate for SQL Server with New-SelfSignedCertificate
How to check SSL encryption is enabled on SQL Server with Powershell
How to check a SQL Server connection is encrypted with SSL
TLS , Sql Server and powershell cmdlet - Get-TLSCipherSuite