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 Convert Images to Base64 Strings in D365 Finance & Operations

In this blog, I will discuss how to convert an image into a base64 encoded string in Dynamics 365 Finance and Operations (D365FO). Fortunate...