bacpac import failed

Question

{"code":"ImportExportJobError","message":"The ImportExport operation with Request Id '69d26d10-22f4-49f0-8ba6-3e9c0a2440ff' failed due to 'An internal error occurred. Please contact Microsoft support and reference the server name, database name, and operation ID.'."}

Answer 1

Hi @Bob Sommer

 Thanks for sharing request id. Look like the export operation getting failed due to an error “AdPassword-login: AADSTS50126: Error validating credentials due to invalid username or password.”

This error message indicates that the credentials used to authenticate with Azure Active Directory (AAD) are invalid. Here are some steps you can take to troubleshoot this issue:

Please verify that the username and password used to authenticate with AAD are correct. You can do this by logging in to the Azure portal with the same credentials and verifying that you can access the resources you need.

Check that the account you are using has the necessary permissions to perform the export operation.

Also please check if the Azure active directory user able to connect to the user databases

If you are still unable to authenticate with AAD, you may consider to reset your password and retry the operation.

Here are the reference document –

https://learn.microsoft.com/en-us/sql/relational-databases/security/authentication-access/azure-ad-authentication-sql-server-overview?view=sql-server-ver16

https://learn.microsoft.com/en-us/azure/azure-sql/database/database-export?view=azuresql

Hope this helps!

Let us know if you have any questions or need additional information.

Thank you!