Dynamics 365 Fin&Ops: Enable maintainanace mode on Environment

In Microsoft Dynamics 365 for finance & operations, enabling of maintenance mode allows you to change configuration, provides a safe way for system administrators to make system changes that might affect system functionality.
In LCS, maintenance mode is turned off by default, You can enable maintenance mode in UAT or Testing Environments, for Production you must submit a service request to DSE team.

There are two methods you can enable maintenance mode to turn maintenance mode on and off in DevTest/Demo environments hosted in a Microsoft subscription

1- SQL

dbo.SQLSYSTEMVARIABLES
set dbo.SQLSYSTEMVARIABLES.VALUE = 1
where dbo.SQLSYSTEMVARIABLES.PARM = ‘CONFIGURATIONMODE’

When you’ve completed your maintenance mode activities, repeat steps 2 and 3, but set the value to 0 in step 2.

dbo.SQLSYSTEMVARIABLES
set dbo.SQLSYSTEMVARIABLES.VALUE = 0
where dbo.SQLSYSTEMVARIABLES.PARM = ‘CONFIGURATIONMODE’

1. Restart the World Wide Web Publishing Service to reset IIS.
2. After the service is restarted, the system will be in maintenance mode.

2- Command Prompt

Note: On some virtual machines (VMs), the exact location of the Deployment.Setup.exe tool might differ. Check AosServiceWebRootbin.

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

You can turn off maintenance mode by running the following command.

J:\AosService\PackagesLocalDirectory\Bin\Microsoft.Dynamics.AX.Deployment.Setup.exe --metadatadir J:\AosService\PackagesLocalDirectory --bindir J:\AosService\PackagesLocalDirectory\Bin --sqlserver . --sqldatabase axdb --sqluser axdbadmin --sqlpwd ********* --setupmode maintenancemode --isinmaintenancemode false

1. Restart the World Wide Web Publishing Service to reset IIS.
2. After the service is restarted, the system will be in maintenance mode.