Automated Backups - Umbraco Cloud Azure Blob Storage and SQL Database

[garethsheldon]

Title: SQLPackage Automation for Umbraco Cloud Backup Fails – Works in SSMS

Questions
Is there a restriction on using SqlPackage or automation tools with Umbraco Cloud-hosted databases?
Are there specific firewall or network rules that block this kind of access?
Is there an official or supported way to automate backups for Umbraco Cloud databases?

Using SqlPackage, I tried automating the backup of an Umbraco Cloud database using Power Automate and PowerShell with Task Scheduler.

However, the process fails with the following error:

The strange part is that the same credentials work perfectly in SSMS.

---

Code Used

# Define variables
$SqlPackagePath = ""  # Adjust if needed
$ServerName = ""       # Replace with your Azure SQL server name
$DatabaseName = ""     # Replace with your database name
$Username = ""         # Replace with your SQL admin username
$Password = ""         # Replace with your password
$BackupPath = " "      # Destination for the .bacpac file

# Run sqlpackage to export the Azure SQL database
& "$SqlPackagePath" /Action:Export `
    /SourceServerName:$ServerName `
    /SourceDatabaseName:$DatabaseName `
    /SourceUser:$Username `
    /SourcePassword:$Password `
    /TargetFile:$BackupPath

# Confirm completion
Write-Host "Azure SQL database '$DatabaseName' backed up to '$BackupPath'."