Dynamics 365 Community Blogs ShabibAX Issue with Bacpac Database ...

Issue with Bacpac Database import in Dev Box using SQLPackage

Shabib raza

129

Like ( 1 )

Report

Hi All,

I started getting error while importing the bacpac file in dynamics tier 1 environment.

Changes to connection setting default values were incorporated in a recent release. More information is available at https://aka.ms/dacfx-connection

This is because of recent changes in encryption policies on SQL. To fix this issue you need to append the import SQL command with /TargetEncryptConnection:False. Following is the full command.

SqlPackage.exe /a:import /sf:J:\MSSQL_BACKUP\UATbackup.bacpac /tsn:localhost /tdn:AXDB_UAT /p:CommandTimeout=1200 /TargetEncryptConnection:False