How can I configure SSL encryption in SQL Server 2014

The Secure Sockets Layer (SSL) can be used to encrypt data transferred on our network between our SQL Server instance and a client application. My question is that can I configure Secure Sockets Layer (SSL) encryption on my SQL Server, While this requires a trusted certificate?


September 15th, 2015 1:42am

Yes possible

see

https://technet.microsoft.com/en-us/library/ms189067(v=sql.105).aspx

Free Windows Admin Tool Kit Click here and download it now
September 15th, 2015 2:04am

If your requirement is to enable and use encryption yes you can do this. First thing is obtain the certificate. 

Most of the organisation they use third party certificates.

here are the steps to configure the certificates in sql server.

https://support.microsoft.com/en-us/kb/316898

September 15th, 2015 2:50am