Using the Azure portal, I am exporting an Azure SQL Database to an Azure Storage Account Container and receive the following error message:
Failed to export the database: sqldb-MyDatabase-145.
ErrorCode: 504
ErrorMessage: The gateway did not receive a response from 'Microsoft.Sql' within the specified time period.
Does anyone know what this error message means? I get it every time I export.
Details:
1. Both the Azure SQL Server and Azure Storage Container are located in Canada Central.
2. The database is configured as a Serverless Gen5 with auto-pause set to 1 hour.
3. The SQL Server and Storage Container are on separate virtual networks.
4. The firewall for the SQL Server is set to:
Allow Azure services and resources to access this server: Yes
Virtual networks list shows both virtual networks with Endpoint status "Enabled".
5. The firewall for the Storage account is set to:
Allow access from: Selected networks
Virtual networks list shows both virtual networks with Endpoint Status "Enabled".
Exceptions: enabled is "Allow trusted Microsoft services to access this storage account"
6. Both virtual networks are configured with:
only a single "default" subnet.
No firewall exists (the default)
Service endpoints: Microsoft.Sql - status "Succeeded", Microsoft.Storage - status "Succeeded"
I've tried various combinations of the above options with no success.
If you know what the error message means, I'd appreciate the feedback.
Thanks.