Unable to export a dataase from an Azure SQL Instance

Anonymous

The Azure SQL Database export function from the portal consistently fails with the following error:

An error occurred while communicating with the SQL Server using AdPassword-login: Could not discover a user realm.

I can provide an operation ID for the export job if that would help. I've found a workaround for this task using SSMS, but as far as I'm concerned the export function in the portal does not work at all.

Anurag Sharma 17,571 Reputation points

2021-09-29T07:15:54.313+00:00

Hi @Anonymous , welcome to Microsoft Q&A forum and apologies for the inconvenience caused to you.

I tried using the Export on Azure SQL Database and was able to successfully export the Database to Storage account.

The error messages it looks like that the communication between Azure SQL Database and Active Directory user is failing. While connecting from SSMS, are you using the Active Directory Password Authentication or SQL Server Authentication?
Jenny Curry 1 Reputation point

2021-09-30T16:43:36.527+00:00

I am having the same issue @Anonymous and @AnuragSharma-MSFT. I using AAD authentication with a service principal. I am aware that I cannot authenticate using a service principal to SMSS, but I should be able to the Sql database.
Giovanni Bassi 6 Reputation points MVP

2021-12-06T23:56:55.987+00:00

I'm having the same issue, but exporting using the az cli. It's exactly the same error message.
drdamour 16 Reputation points

2022-04-01T13:26:08.93+00:00

i have the same interest, i would like to use an AzAD Service Principal to perform this export. Is this supported?
Claas Wunderlich 0 Reputation points Microsoft Employee

2022-05-26T20:19:38.213+00:00

seeing the same error using powershell New-AzSqlDatabaseExport
Gerardo Buenrostro 1 Reputation point

2023-12-27T21:46:52.3933333+00:00

Same problem 2 years later. No fix I suppose?