Error importing database: Could not import package
Views (27)
fsilva-jr
20
Like
Share
ReportIf you find this error when importing a .bacpac package to your SQL Server pay attention to the way you are authenticating your connection to SQL Server, even if you are connected into the SQL instance server.
Your line of connection must have this additional parameter:
/TargetTrustServerCertificate:True
Example: SqlPackage.exe /a:import /sf:c:\temp\backup.bacpac /tsn:localhost /targetTrustServerCertificate:True /tdn:AxDBN /p:CommandTimeout=600
If you want to know more about it, go to this place:
https://techcommunity.microsoft.com/t5/azure-sql-blog/connection-security-improvements-in-sqlpackage-161/ba-p/3672758
This was originally posted here.
*This post is locked for comments