TLS 1.2 encryption between Azure Data Factory and On-Prem SQL server DB

Question

I have a requirement for connecting my Datafactory to SQL Server present in On-Prem. I have created a SHIR and established the communication between SHIR and On-Prem SQL Server.

I want to encrypt my connection channel between SHIR and On-Prem SQL Server. How can i do that.
How to test if the connection is encrypted or not.

Answer 1

Hello @Sukumar Vinnakota ,

Thanks for the question and using MS Q&A platform.

By default, the traffic between ADF and SHIR is through TLS1.2, the onprem to cloud data movement happen through TLS1.2 encryption, but the traffic between SHIR and your service encryption depends on your service protocol (HTTPS, SFTP etc).

All data transfers are via secure channel HTTPS and TLS over TCP to prevent man-in-the-middle attacks during communication with Azure services.

For more details, refer to Security considerations for data movement in Azure Data Factory.

Hope this helps. Do let us know if you any further queries.

---------------------------------------------------------------------------

Please "Accept the answer" if the information helped you. This will help us and others in the community as well.

Answer 2

Hi @Sukumar Vinnakota ,

TLS 1.2 is enabled by default on Windows 10, version 1507+ and Windows Server 2012+.

How to test if the connection is encrypted or not.

Here is a link about SSL vs TLS : https://www.globalsign.com/en/blog/ssl-vs-tls-difference
If your connection is not using TLS 1.x, you may receive an error.
Configure TLS Settings In Windows 10: https://www.kapilarya.com/how-to-configure-tls-settings-in-windows-10

Best regards,
Seeya

---

If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.