0

I have a SAS URI (read, list) for an ADLS hosted in another resource group. While I try to connect to that ADLS using the SAS URI, I get successful connection but unable to copy or browse files.

Databricks Error: Server failed to authenticate the request. Make sure the value of Authorization header is formed correctly including the signature.&#34

ADF Error suggestion list:

  1. Grant service principal or managed identity appropriate permissions to do copy.
  2. It's possible because some IP address ranges of Azure Data Factory are not allowed by your Azure Storage firewall settings.
  3. The remote server returned an error: (403) Forbidden.StorageExtendedMessage=Server failed to authenticate the request. Make sure the value of Authorization header is formed correctly including the signature.

What is the possible reason and how to resolve it?

The same SAS URI works with Azure Storage Explorer hosted in a VM and I am able to copy files. So, the key is not expired.

Swagat Mohanty
  • 1

1 Answers1

0

What is the possible reason and how to resolve it?

Found some possible reasons causing the error:

  • The SAS token you are using for a connection is incorrect/expired.
  • The time zone difference in your pc time and time generated while creating SAS token.
  • Firewall restrictions on ADLS (Whitelist your ADF IP and Client IP).

As you said Main requirement is to use ADF to copy files from that External ADLS. I tried it in my environment and get it done successfully.

check if you are missing anything:

  • Generate SAS token with permission you want and copy it as below enter image description here enter image description here
  • Pass this SAS token in authentication enter image description here
  • Successfully able to bowse the files. enter image description here

Also, refer this SO thread with similar issue.

Pratik Lad
  • 4,343
  • 2
  • 3
  • 11