Published
Mar 13 2019 06:47 PM
5,148
Views
First published on MSDN on Sep 07, 2017
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.
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.
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.