Thursday, 28 June 2018

Change maintenance mode for license configuration in D365

In this blog we will discuss, how to change maintenance mode for license configuration in Dynamics365. When we need to enable / disable configuration key we can do it by going at navigation System administration > Setup > License configuration by this setup we can enable / disable configuration key. By-default in D365 License configuration setup is disable due to maintenance mode is set to False








In order to enable or disable configuration we need to change the maintenance mode to True. There are two ways to achieve it: (1) By Sql Query, (2) By Command

By Sql Query:
--System variable table having system settings and configurations.
update SQLSYSTEMVARIABLES
--Set value to 1 (True).
set SQLSYSTEMVARIABLES.VALUE = 1
--Where clause of configuration mode.
where PARM = 'CONFIGURATIONMODE'









By Command:
C:\AosService\PackagesLocalDirectory\Bin\Microsoft.Dynamics.AX.Deployment.Setup.exe –metadatadir C:\AosService\PackagesLocalDirectory –bindir C:\AosService\PackagesLocalDirectory\Bin –sqlserver . –sqldatabase axdb –sqluser <SQL admin user id> –sqlpwd <SQL users password> –setupmode maintenancemode –isinmaintenancemode true

Note: Change drive command in my case I have "C Drive" and change SQL user and password accordingly.

After using one of the method to change the maintenance mode, restart IISServer.
That is all you need to do.

1 comment:

  1. i disabled maintenance mode by sql query , but the status in lcs still in maintenance , so how to change this status now ? , also maintenance mode is not visible in maintain menu , thank you for your help

    ReplyDelete

How to Get Customer Free Text Invoice "Totals" form field value with X++ in D365FO

Customer free text invoices are an essential aspect of financial management in D365FO. In this blog, I have compiled all the code needed to ...