asked
How to encrypt sql server connections using TLS1.2
Hi Friends, How can i encrypt all sql server connections using TLS1.2. Do we need a certificate for this ? If so how do we get this and which certificate do we need to get? Can some one provide me some detailed steps on this.What is the difference between SSL and TLS . Sorry, i haven't done this before , hence all these questions.
From what I understand (I'm not an expert in this area), yes you will need a TLS certificate. TLS is an advanced version of SSL but both are valid methods to encrypting the connection. You should be able to obtain either type of certificate from you certificate authority (CA) of choice. Here are some references: -
https://www.globalsign.com/en/blog/ssl-vs-tls-difference/ -
https://blogs.msdn.microsoft.com/sqlserverfaq/2012/04/04/can-tls-certificate-be-used-for-sql-server-encryption-on-the-wire/ -
https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/enable-encrypted-connections-to-the-database-engine You will want to verify that your existing build supports TLS 1.2 which you can do here:
https://support.microsoft.com/en-us/help/3135244/tls-1.2-support-for-microsoft-sql-server Hope that helps
19 People are following this question.
