Importing Azure SQL DB from bacpac - Login Failed

DavidPendleton-7654 26 Reputation points
2025-02-03T17:09:51+00:00

I am attempting to import a database from a bacpac. The database is created, but the process fails shortly afterwards with the following error message:

{"code":"ImportExportJobError","message":"The ImportExport operation with Request Id '<removed>' failed due to 'The ImportExport operation with Request Id '<removed>' failed due to 'An unexpected error was returned by SQL. Error number: 0, State: 0, Message: Failed to authenticate the user <removed> in Active Directory (Authentication=ActiveDirectoryPassword).\nError code 0xuser_realm_discovery_failed\nResponse status code does not indicate success: 400 (BadRequest). .'.'."}

My Microsoft Entra Admin ID is set for the SQL Server:

User's image

And, the same Admin name is pre-populated in the Portal when I initiate the database import. I am providing the password for my Microsoft Account that I use for Windows, the Azure Portal, etc.

What am I missing here?

Azure SQL Database
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.