database restore from LCS to local on D365FO after 10.0.39

Error message : Receive the following error while importing a bacpac to a Dev environment

 

Error SQL72014: Framework Microsoft SqlClient Data Provider: Msg 4630, Level 16, State 1, Line 1 The permission 'KILL DATABASE CONNECTION' is not supported in this version of SQL Server. Alternatively, use the server level 'ALTER ANY CONNECTION' permission.

Error SQL72045: Script execution error.  The executed script:

GRANT KILL DATABASE CONNECTION TO [ms_db_configreader];

 

Steps to resolve the issue:

Step 1: Rename the BACPAC file to .zip,Go to the folder where you have saved your BACPAC file and rename the BACPAC file with a .zip extension, Press "Yes" to convert the .bacpac file to zip file.

Step 2 : Open zip file ,  

Step 3: Copy the model.xml file into the different location
Step 4: Open it in VS Code editor.

Step 5.  Delete the entire Element tag which contains " Grant.KillDatabaseConnection " 

 Step 6. After deletion of the element type mentioned in Step 5. it look like below.

Step 8: Download the latest SqlPackage file from the below link:

https://learn.microsoft.com/en-us/sql/tools/sqlpackage/sqlpackage-download?view=sql-server-ver16

Step 7:  Rename the the file modelCopy.xml  and paste it in the SqlPackage folder.

Step 8: Rename the zipfile to bacpac file  (reverting back the changes from step 1)

Step 8: Login to command prompt as administrator. 

Step 9:  Navigate to the downloaded SQLPackage folder and run the below command.

SqlPackage.exe /a:import /sf:"J:\MSSQL_BACKUP\AxDB.bacpac" /tsn:localhost /tdn:AXDB_New /p:CommandTimeout=1200 /TargetTrustServerCertificate:True /mfp:"ModelCopy.xml" 

This will resolve your issue of Importing the Bacpac file into D365 F&O Tier 1 environments