paone
paone

Reputation: 937

SSIS connect to Azure Blob Storage 403 forbidden error

I am using SSIS 2019 and installing the Azure feature pack trying to connect Azure Blob Storage and download files on-premise. When executing the task it errors. Installed TLS 1.2 version.

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

Add new values named SystemDefaultTlsVersions with DWORD value=1

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

Error Message: [Azure Blob Download Task] Error: Download task has stopped with exception: The remote server returned an error: (403) Forbidden.

enter image description here

enter image description here

And still run into 403 error.

Upvotes: 2

Views: 272

Answers (1)

Narthring
Narthring

Reputation: 1439

The traffic may be blocked at the storage account. Take a look at the networking blade for the storage account to see if your IP is being blocked.

Storage account networking blade

Upvotes: 0

Related Questions