D365 F&O -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];

 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 notepad 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

 

D365 F&O Management Reporter Troubleshoot issues opening Report Designer

 

Issue 1 - Report Designer doesn't start when you select "New" or "Edit"

Resolution

Check the Event Viewer:   If the Issue related to Change Tracking :

Run the below script:

ALTER DATABASE AxDB SET CHANGE_TRACKING = ON (CHANGE_RETENTION = 2 DAYS, AUTO_CLEANUP = ON)

IF related to User Permission:

To solve this issue, follow these steps:

• In Internet Explorer, select Settings > Internet Options > Security > Trusted Sites > Sites. In the Add this website to zone field, enter \*\.dynamics.com, and then select Add.

• In Internet Explorer, select Settings > Internet Options > Security > Trusted Sites. In the area labeled Security level for this zone, change the option to Medium-Low.

• Disable the pop-up blocker in your browser.

• Install Microsoft .NET Framework 4.7.2 or higher to workstations.

• If you're using the Chrome browser, you must install the ClickOnce extension to download the Report Designer client. If you're running Chrome in incognito mode, make sure the ClickOnce extension is enabled for incognito mode. For more information about the Chrome ClickOnce extension, see System requirements for cloud deployments.

• If you're using Microsoft Edge with the Chrome browser, you don't need to install the ClickOnce extension for Microsoft Edge Chromium. However, you must enable the ClickOnce option to download the Report Designer client. If you're running incognito mode, make sure the ClickOnce extension is enabled for incognito mode.

1. Open a new browser in Microsoft Edge.
2. Enter edge://flags and select Enter.
3. Search for the ClickOnce Support option or use this direct link: edge://flags/#edge-click-once.
4. Set the drop-down menu option to Enabled.
5. Select Restart Browser.

Management Reporter Connection Issue

 

1. Issue: Unable to connect to Management Reporter and received below mentioned errors:

2. Taken UAT DB Write Access to run the script shared by Microsoft:

Script #2: Script should run on the AxDB:

UPDATE FINANCIALREPORTINGSETTINGS SET SETTINGVALUE = 0 WHERE SETTINGKEY = 'DisableMaps';
IF @@ROWCOUNT=0 INSERT INTO FINANCIALREPORTINGSETTINGS(SETTINGVALUE, SETTINGKEY) VALUES (0, 'DisableMaps')

Step#2:Re-start MR services after running the above script

3. Run the script in UAT AxDB

 

4. Executed the script:

 

5. Restart the MR Service from LCS
6. Click on Restart Service
    

 

7. Select the Financial Reporting Service

8. Again, try to open the Financial Reports: