question

rehaan avatar image
rehaan 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.
securityencryptionconnectivity
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
JohnM avatar image
JohnM answered
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
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thank You so much John M. Much appreciated.I will read all of those articles and will come back if i have any doubts.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.