[Solved] Dynamics 365FO DB restore error Line 1 The permission 'KILL DATABASE CONNECTION' is not supported in this version of SQL Server.


[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.


Article 3w

Login now to access my digest by 365.Training

Learn how my digest works
Features
  • Articles, blogs, podcasts, training, and videos
  • Quick read TL;DRs for each item
  • Advanced filtering to prioritize what you care about
  • Quick views to isolate what you are looking for right now
  • Save your favorite items
  • Share your favorites
  • Snooze items you want to revisit when you have more time