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:

 

Install and Configure Zpl Printer on D365 F&O

 

Setup Zpl Printer On D365 F&O

Posted on

Recently, I have had an opportunity review the possibilities to print license plates within D365.  Unfortunately, there is no peripheral simulator available in Microsoft Dynamics 365 for Finance and operations. But there is an ability to do a tricky move by setting up the Zpl printer Chrome extension.

Use the link below to install Zpl printer Chrome extension:

https://chrome.google.com/webstore/detail/zpl-printer/phoidlklenidapnijkabnfdgmadlcmjo

Once you install that, keep it running.

Go to Control pane > Devices and Printers on your laptop.

Click Add a printer button.

Click The printer that is I want isn’t listed link.

Click Add a local printer or network printer with manual settings.

Click Create a new port.

Choose Type of port = Standard TCP/IP port.

Click Next button.

Set Host name or IP address = 127.0.0.1

Keep Query the printer and automatically select the driver to use as YES.

Click Next button.

Wait until Detecting TCP/IP port operation is completed.

Select Device type = Custom.

Click on Settings button.

Make sure that:

Port name = 127.0.0.1

Printer name or IP address = 127.0.0.1

Protocol = RAW

Port number = 9100

Click OK button.

Click Next button.

In the Install the printer driver, select Generic / Text only.

Click Next button.

In the Printer name, type in the Printer name like Zebra printer.

Click Next button.

Set Do not share this printer.

Click Next button.

Click Finish button.

Go to Organization administration > Setup > Network printers.

Click Download document routing agent installer.

Open document routing agent installer.

Click Next button.

Read End-user agreement and set I accept the terms in the License Agreement.

Click Next button.

Keep Destination folder as suggested by wizard.

Click Next button.

Click Install button.

Wait until completed.

Click Finish button.

Open Document routing app installed on desktop.

No need to sign in.

Click Settings button.

In the Dynamics 365 URL set URL address of the D365FO environment.

In the Azure AD Tenant set tenant of the D365FO environment.

Click OK button.

Reopen Document routing app installed on desktop.

Sign in using your credentials.

Click Printers button.

Set flag next to Zebra printer.

Click Register button.

Go to Organization administration > Setup > Network printers.

Change Active flag to YES.

If you want to print something, do not close ZPL Printer and Document routing apps. They both should be up and running.