Blog Post

Azure Database Support Blog
1 MIN READ

How to get more information about failed import to Azure SQL DB

Yochanan_Rachamim's avatar
Mar 14, 2019
First published on MSDN on Sep 07, 2017

Scenario:


If you try to import bacpac to Azure SQL DB and it failed you will probably get this indication from the notification



Figure 1 – notification on failed import operation.


Also, in "Import / Export History" sometimes (depend on the failure reason) you may not see any records for the failed import



Figure 2 – no information shows in Import/Export History

As this does not give you more information about the reason for the failure this article explains how to get this information.

Solution:


Click on the resource group where the Azure SQL Server is located (you have link to the resource group from the server's overview blade)

Click on Deployment under the correct Resource Group

Click on "Error Details" on the import deployment that had the failure



Figure 3 – error details.


As you can see in my case the import failed due to bad login name and password.

The exception states that: Login failed for user Yochanan.
Published Mar 14, 2019
Version 1.0
No CommentsBe the first to comment