all AI news
Fix "The permission 'KILL DATABASE CONNECTION' is not supported in this version of SQL Server" while importing a D365FO .bacpac
May 27, 2024, 2:58 a.m. | Eduardo Silva Rossi
DEV Community dev.to
Recently, while making a copy of production database to my development environment, I came across an unusual error when importing the .bacpac file using SqlPackage:
*** Error importing database: Could not import package.
Error SQL72014: Core 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: …
copy core data database development environment erp error file fix import making microsoft package permission production provider server sql while
More from dev.to / DEV Community
Jobs in AI, ML, Big Data
Senior Data Engineer
@ Displate | Warsaw
Lead Python Developer - Generative AI
@ S&P Global | US - TX - VIRTUAL
Analytics Engineer - Design Experience
@ Canva | Sydney, Australia
Data Architect
@ Unisys | Bengaluru - RGA Tech Park
Data Architect
@ HP | PSR01 - Bengaluru, Pritech Park- SEZ (PSR01)
Streetlight Analyst
@ DTE Energy | Belleville, MI, US