How to Enable/Disable Maintenance Mode in D365FO on-premises

In D365FO, Maintenance mode puts the system in a safe mode to make major changes that might affect the whole system functionality. When activated, all users are unable to perform except the system administrator.

For cloud-hosted deployments( Tier2 and above), we can enable/disable the maintenance mode on LCS.

For On-premises deployment, One way to do so is to run an SQL command on the database.

I. To to the DB server and open SQL studio

II. Go to AXDB and run the following queries as the case may be.

• To check current state

             select Value from sqlsystemvariables a where a.PARM = ‘configurationmode’

• To enable maintenance mode

             update sqlsystemvariables set VALUE = 1 where PARM = ‘configurationmode’

Now restart the Service fabric Host service on all AOS machines. Sometimes it doesn’t work and you need to restart the AOS machines

• Having peformed the desired task(s), disable maintenance mode

update sqlsystemvariables set VALUE = 0 where PARM = ‘configurationmode’

Voilà !