SQL Backup to Azure Only Can Use Shared Access Signature

Question

I am using SQL 2022 to test backing up to an Azure Storage account. We already have key vault in place that rotates the keys on storage account but it appears SQL only wants to use a SAS is this correct?

Answer 1

Hi @rr-4098,

Thank you for your reaching out and welcome to Microsoft Q&A!

but it appears SQL only wants to use a SAS

Could you please tell us are you using the Azure Blob storage? Please refer to this official documentation, we can get the information below:

Feel free to share your issues here if you have any concerns!

Best regards,

Lucy Chen

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

https://docs.microsoft.com/en-us/answers/support/email-notifications

Answer 2

@rr-4098 Welcome to Microsoft Q&A FOrum, Thank you for posting your query here!
When backing up SQL Server 2022 to an Azure Storage account, SQL Server primarily supports authentication using Shared Access Signature (SAS) tokens or storage account keys. Other authentication methods, such as using Microsoft Entra ID (formerly Azure Active Directory), are not supported for this purpose

If you have any more questions or need further assistance, feel free to ask!

References

SQL Server Backup to URL for Microsoft Azure Blob Storage - SQL Server | Microsoft Learn

Quickstart: SQL backup and restore to Azure Blob Storage

Azure Key Vault
Create SAS tokens for your storage containers

Please let us know if you have any further queries. I’m happy to assist you further. 

---

  Please do not forget to "Accept the answer” and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.