Getting TlsVersionNotPermitted error when SSIS package executing from ADF

Question

Hi,
I have created one SSIS package which is reading data from Storage account and putting that into Azure DB. This is working perfectly well when executing from Visual Studio. But when I am triggering it after deployment in ADF, getting below error.
ForEachLoopContainer: Error: Com error object information is available. Source: "Microsoft.DataTransfer.ClientLibrary" error code: 0x80131500 Description: "ADLS Gen2 operation failed operation returned an invalid status code "Bad request".
ErrorCode: "TlsVersionNotPermitted"
message: TLS version of this connection is not permitted on this storage account.
I can see that Storage account has TLS version 1.2
Can someone please help.

Answer 1

Hello @Vikas and welcome to Microsoft Q&A.

I understand this would be very frusterating. There are a few possible causes. Can you tell me if you are using a self-hosted integration runtime to get to a Storage account inside a vnet?

If not, there are a couple options. You could try lowering the Storage account TLS version, or you could try enabling stronger TLS on the SSIS Integration Runtime (instructions for configuring here). Add to your main.cmd:

reg add HKLM\SOFTWARE\Microsoft\.NETFramework\v4.0.30319 /v SchUseStrongCrypto /t REG_DWORD /d 1 /reg:64  
reg add HKLM\SOFTWARE\Microsoft\.NETFramework\v4.0.30319 /v SchUseStrongCrypto /t REG_DWORD /d 1 /reg:32