Problem Description:
Azure SQL backup is failing with an error code AZURE_SQL1022
Traceback
azsqlioserver.log
error: Internal error failed to handle keyvault: failed to get key from keyvault
Cause:
This error occurs when the Azure Key Vault is not reachable due to missing firewall rules in the associated Virtual Network (VNet) used by Quantum Bridge.
Resolution:
Add the required firewall rules in the associated VNet where the Quantum bridge is deployed to allow access to the following service:
Azure Key Vault.
Find the exact Key Vault URL.
Log in to Azure Portal.Go to Resources.
Find the Key Vault: click on Key and copy the exact URL.
EG:URL Format:
https://xxxx-drv-<Siteid>-<Subscriptionid>.vault.azure.net/Whitelist the URL in the firewall that is associated with the Quantum Bridge VM VNET.
Once the rules were updated, the backup job successfully retrieved the key from Key Vault and completed without errors.
Verification:
Trigger a manual backup from the console.
Verify the job status transitions from Queued to Running and finally Successful.