SQL DB export to Storage Account with Private link is failing

Question

I am trying to export the database to storage account which has following feature

Tool or method used to export - Using Portal

Attempting to backup/export db to Storage Account in same RG.

Azure SQL DB is using Private Link

Storage Account does not currently have Private Link

Allow Microsoft Services is turned on for both resources

Attempted using email, user@domain, and sql admin

PS - Based on common issues that we have seen from customers and other sources, we are posting these questions to help the Azure community.

Answer 1

Greetings!

Welcome to Microsoft Q&A forum.

Based on the details provided there are possible root causes, resolutions and questions that I would like to share is-

• If you are encountering issues with private endpoint connection, it is recommended to approve the private endpoint connection on the Azure SQL Database. You can navigate to the Networking page under Security and select the Private access tab to perform this action.

•Regarding the storage account firewalls, adding IP ranges to the network list may not be helpful for Database Export/Import operations. Instead, it is advised to allow all networks in the storage account firewalls.

• If you are still experiencing difficulties with the export, you can consider using SSMS or sqlpackage.exe to perform the export operations from your local machine. The relevant document provides a link to the documentation that explains how to export to a BACPAC file using the sqlpackage utility. - Export a database to a BACPAC file - Azure SQL Database & Azure SQL Managed Instance | Microsoft Learn

Thank You!