question

SukumarVinnakota-8083 avatar image
0 Votes"
SukumarVinnakota-8083 asked PRADEEPCHEEKATLA-MSFT commented

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

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.

sql-server-generalazure-data-factory
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @SukumarVinnakota-8083,

Just checking in to see if the below answers helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

0 Votes 0 ·

Hello @SukumarVinnakota-8083,

Following up to see if the below suggestion was helpful. And, if you have any further query do let us know.

0 Votes 0 ·
SeeyaXi-msft avatar image
0 Votes"
SeeyaXi-msft answered

Hi @SukumarVinnakota-8083,


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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

PRADEEPCHEEKATLA-MSFT avatar image
0 Votes"
PRADEEPCHEEKATLA-MSFT answered

Hello @SukumarVinnakota-8083,

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.