Use Azure authentication to connect to Azure SQL servers


I can connect to Azure SQL using the Server admin login set up in Azure.
But are we able to Authenticate using Azure Entra ?


Hello Colin,

We regret to inform you that there is no way to achieve this through SQLBackupAndFTP.

If you have any other questions, please feel free to let us know.

Thank you, and we apologize for any inconvenience.


its not a deal breaker.
all my testng is done.
i will purchase a license now.

Hello Colin,

Good news! Please feel free to contact us for any issues or concerns.

Thank you for using SQLBackupAndFTP.


As a follow up to this.
im aware that we have to use the Server admin login within the Azure SQL to create backups.

What are the minimal permissions required in Azure SQL for the backup to operate ?

Hello Colin_Kent,

On Azure SQL Database, you need to grant VIEW DEFINITION and SELECT permissions for each database, either on all tables or specific tables.

Please find more details at Export a Data-tier Application - SQL Server | Microsoft Learn

If you have any other questions, please let us know.

Thank you!