[Solved] Dynamics 365FO DB restore error Line 1 The permission 'KILL DATABASE CONNECTION' is not supported in this version of SQL Server. The recommended solution is to navigate to the folder where the BACPAC file is saved, change the file extension from .bacpac to .zip, open the zip file and copy the model.xml file to a different location, delete the entire Element tag that contains 'Grant.KillDatabaseConnection' in the copied model.xml file, save the modified file as ModelCopy1.xml, paste the modified file into the SqlPackage folder, change the file extension of the zip file back to .bacpac, and execute the SQLPackage command.
Login now to access my digest by 365.Training