Turn maintenance mode on and off in DevTest/Demo environments hosted in Microsoft subscription
Nisham Sainullabdeen
![Nisham Sainullabdeen]()
Nisham Sainullabdeen
Dynamics 365 Infrastructure Expert || Azure Solutions Architect || Cloud & On-Premise Specialist || Dynamics 365 Commerce Infrastructure Expert || Omnichannel Retail Architect
1. Establish an RDP connection to the developer machine.
2. On the developer machine, sign into SQL Server by using the credentials for the axdbadmin user from LCS. Then switch to the AXDB database and run the following command.
update SQLSYSTEMVARIABLES set VALUE = 1 where PARM = 'CONFIGURATIONMODE'
3. Restart the World Wide Web Publishing Service to reset IIS.
4. After the service is restarted, the system will be in maintenance mode.
5. When you have completed your maintenance mode activities, repeat steps 2 and 3, but set the value to 0 in step 2
Sr. Manager IT Infra
1 年#Enable Maintenance mode(Sign in to the VM and Run SSMS in admin mode-run the below against AxDB) #Step 1: USE AxDB; update SQLSYSTEMVARIABLES SET VALUE = 1 where PARM = 'CONFIGURATIONMODE' select * from SQLSYSTEMVARIABLES where PARM = 'CONFIGURATIONMODE' #Step 2: Restart World Wide Web Publishing Service - PS Commands Get-Service -Name W3SVC |ft Name,Status,Machinename,Starttype –autosize Restart-Service -Name W3SVC -Verbose |ft Name,Status,Machinename,Starttype -autosize Get-Service -Name W3SVC |ft Name,Status,Machinename,Starttype –autosize #Disable Maintenance mode(Sign in to the VM and Run SSMS in admin mode-run the below against AxDB) #Step 1: USE AxDB; Update SQLSYSTEMVARIABLES SET VALUE = 0 where PARM = 'CONFIGURATIONMODE' select * from SQLSYSTEMVARIABLES where PARM = 'CONFIGURATIONMODE' #Step 2: Restart World Wide Web Publishing Service - PS Commands Get-Service -Name W3SVC |ft Name,Status,Machinename,Starttype –autosize Restart-Service -Name W3SVC -Verbose |ft Name,Status,Machinename,Starttype -autosize Get-Service -Name W3SVC |ft Name,Status,Machinename,Starttype –autosize
Functional Consultant - MS D365 Fin Ops I Certified SAFe? Practitioner.
3 年Very informative