Wednesday 4 August 2021

Copy Data from On-Prem to Azure Blob via SSIS failed with TLS error

Copy Data from On-Prem to Azure Blob via SSIS using Feature pack for Azure failed with TLS error:

Error:

Microsoft.DataTransfer.ClientLibrary.BinaryTransfer.Run(),''Type=Microsoft.WindowsAzure.Storage.StorageException,Message=The remote server returned an error: (400) Bad Request.,Source=Microsoft.WindowsAzure.Storage,StorageExtendedMessage=The TLS version of the connection is not permitted on this storage account.

Solution as per Microsoft:

Use TLS 1.2

The TLS version used by Azure Feature Pack follows system .NET Framework settings. To use TLS 1.2, add a REG_DWORD value named SchUseStrongCrypto with data 1 under the following two registry keys.

HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\.NETFramework\v4.0.30319
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\.NETFramework\v4.0.30319

Ref: https://docs.microsoft.com/en-us/sql/integration-services/azure-feature-pack-for-integration-services-ssis?view=sql-server-ver15#use-tls-12

No comments:

Post a Comment