Enable/disable D365 maintenance mode

Tier 2: Enable/disable D365 maintenance mode can be done from LCS:

There are the following ways to enable/disable maintenance mode on DEV/could hosted boxes:

SQL

Query status:
use AXDB;
select * from dbo.SQLSYSTEMVARIABLES where PARM = 'CONFIGURATIONMODE';
Enable maintenance mode:
use AXDB;
update SQLSYSTEMVARIABLES SET VALUE = 1 where PARM = 'CONFIGURATIONMODE';
Restart IIS Expres/IIS and do the required steps like enable/disable configuration keys.
Execute DB sync

Disable maintenance mode:
use AXDB;
update SQLSYSTEMVARIABLES SET VALUE = 0 where PARM = 'CONFIGURATIONMODE';

CMD

Open command prompt as administrator.
Enable maintenance mode (replace **axdbadmin_from_lcs** value):
K:\AosService\PackagesLocalDirectory\Bin\Microsoft.Dynamics.AX.Deployment.Setup.exe --metadatadir J:\AosService\PackagesLocalDirectory --bindir J:\AosService\PackagesLocalDirectory\Bin --sqlserver . --sqldatabase axdb --sqluser axdbadmin --sqlpwd **axdbadmin_from_lcs** --setupmode maintenancemode --isinmaintenancemode true
Disable maintenance mode (replace **axdbadmin_from_lcs** value):
K:\AosService\PackagesLocalDirectory\Bin\Microsoft.Dynamics.AX.Deployment.Setup.exe --metadatadir J:\AosService\PackagesLocalDirectory --bindir J:\AosService\PackagesLocalDirectory\Bin --sqlserver . --sqldatabase axdb --sqluser axdbadmin --sqlpwd **axdbadmin_from_lcs** --setupmode maintenancemode --isinmaintenancemode false

D365FO.Tools

Open PowerShell as Administrator
Installation of d365fo tools:
Install-Module -Name d365fo.tools
Query status:
Get-D365MaintenanceMode
Enable maintenance mode:
Enable-D365MaintenanceMode
Disable maintenance mode:
Disable-D365MaintenanceMode
List of all d365fo tools commands:

 

Search

About

DaxOnline.org is free platform that allows you to quickly store and reuse snippets, notes, articles related to Dynamics AX.

Authors are allowed to set their own AdSense units.
Join us.

Blog Tags